def roundFieldValue(self, n, table, field):
from pineboolib.fllegacy.FLSqlConnections import FLSqlConnections
tmd = FLSqlConnections().database().manager().metadata(table)
if not tmd:
return 0
fmd = tmd.field(field)
if not fmd:
if tmd and not tmd.inCache():
del tmd
return 0
ret = self.buildNumber(n, 'f', fmd.partDecimal())
if tmd and not tmd.inCache():
del tmd
return ret
def roundFieldValue(self, n, table, field):
from pineboolib.fllegacy.FLSqlConnections import FLSqlConnections
tmd = FLSqlConnections().database().manager().metadata(table)
if not tmd:
return 0
fmd = tmd.field(field)
if not fmd:
if tmd and not tmd.inCache():
del tmd
return 0
ret = self.buildNumber(n, 'f', fmd.partDecimal())
if tmd and not tmd.inCache():
del tmd
return ret
def quickSqlSelect(self, f, s, w, connName="default"):
from pineboolib.fllegacy.FLSqlConnections import FLSqlConnections
if not w:
sql = "select " + s + " from " + f
else:
sql = "select " + s + " from " + f + " where " + w
q = FLSqlQuery(sql, FLSqlConnections().database(connName).db())
return q.value(0) if q.next() else False
def setMainWidgetEmpty(self):
if not self.action_:
return
if self.cursor_:
self.setMainWidgetQWidget(self.cursor_.db().managerModules.createUI(self.action_, self, self))
else:
self.setMainWidget(FLSqlConnections.database().managerModules().createUI(self.action_, self, self))
def setMainWidgetString(self, uiFileName):
if self.cursor_:
self.setMainWidgetQWidget(
self.cursor_.db().managerModules.createUI(
uiFileName, self, self))
else:
self.setMainWidget(
FLSqlConnections.database().managerModules().createUI(
uiFileName, self, self))
def init2(self, cursor,actionName = QString.null, parent = None):
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = False
elif cursor:
self.action_ = FLSqlConnections.database().manager().action(actionName)
self.cursor_ = cursor
if self.action_:
self.name_ = self.action_.name()
else:
self.name_ = QString.null
def setMainWidgetEmpty(self):
if not self.action_:
return
if self.cursor_:
self.setMainWidgetQWidget(
self.cursor_.db().managerModules.createUI(
self.action_, self, self))
else:
self.setMainWidget(
FLSqlConnections.database().managerModules().createUI(
self.action_, self, self))
def init2(self, cursor, actionName=QString.null, parent=None):
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = False
elif cursor:
self.action_ = FLSqlConnections.database().manager().action(
actionName)
self.cursor_ = cursor
if self.action_:
self.name_ = self.action_.name()
else:
self.name_ = QString.null
def init1(self, actionName, parent = None):
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = False
print(FLUtil.translate("app","FLFormSearchDB : Nombre de acción vacío"))
return
else:
self.action_ = FLSqlConnections.database().manager().action(actionName)
if not self.action_:
print(FLUtil.translate("app","FLFormSearchDB : No existe la acción %s" % actionName))
return
self.cursor_ = FLSqlCursor(self.action_.table(), True,"default", 0, 0, self)
self.name_ = self.action_.name()
self.initForm()
def inicialize2(self, *args, **kwargs):
actionName = str(args[0][0])
parent = args[0][1]
f = args[1]
if parent:
self.parent_ = parent
else:
self.parent_ = QtGui.QWidget(pineboolib.project.mainWidget(),
actionName, f)
self.layout = None
self.mainWidget_ = None
self.layoutButtons = None
self.pushButtonCancel = None
self.showed = False
self.iface = None
self.oldCursorCtxt = None
self.isClosing_ = False
self.initFocusWidget_ = None
self.oldFormObj = None
self.accepted_ = False
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = None
print(FLUtil.translate("sys", "FLFormDB : Nombre de acción vacío"))
return
else:
self.action_ = FLSqlConnections.database().manager().action(
actionName)
if not self.action_:
print(
FLUtil.translate(
"sys", "FLFormDB : No existe la acción %s" % actionName))
return
self.cursor_ = FLSqlCursor(self.action_.table(), True, "default", 0, 0,
self)
self.name_ = self.action_.name()
self.initForm()
def inicialize2(self,*args, **kwargs):
actionName = str(args[0][0])
parent = args[0][1]
f = args[1]
if parent:
self.parent_ = parent
else:
self.parent_ = QtGui.QWidget(pineboolib.project.mainWidget(), actionName, f)
self.layout = None
self.mainWidget_ = None
self.layoutButtons = None
self.pushButtonCancel = None
self.showed = False
self.iface = None
self.oldCursorCtxt = None
self.isClosing_ = False
self.initFocusWidget_ = None
self.oldFormObj = None
self.accepted_ = False
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = None
print(FLUtil.translate("sys","FLFormDB : Nombre de acción vacío"))
return
else:
self.action_ = FLSqlConnections.database().manager().action(actionName)
if not self.action_:
print(FLUtil.translate("sys","FLFormDB : No existe la acción %s" % actionName))
return
self.cursor_ = FLSqlCursor(self.action_.table(), True, "default", 0, 0, self)
self.name_ = self.action_.name()
self.initForm()
def inicialize3(self, *args, **kwargs):
cursor = args[0]
actionName = args[1]
parent = args[2]
f = args[3]
self.cursor_ = cursor
self.layout = None
self.mainWidget_ = None
self.layoutButtons = None
self.pushButtonCancel = None
self.showed = False
self.iface = None
self.oldCursorCtxt = None
self.isClosing_ = False
self.initFocusWidget_ = None
self.oldFormObj = None
self.accepted_ = False
if parent:
self.parent_ = QtGui.QWidget(parent)
else:
self.parent_ = QtGui.QWidget(pineboolib.project.mainWidget(),
actionName, f)
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = None
elif cursor:
self.action_ = cursor.db().manager().action(actionName)
else:
self.action = FLSqlConnections.database().manager().action(
actionName)
if self.action_:
self.name_ = self.action_.name()
def inicialize3(self, *args, **kwargs):
cursor = args[0]
actionName = args[1]
parent = args[2]
f = args[3]
self.cursor_ = cursor
self.layout = None
self.mainWidget_ = None
self.layoutButtons = None
self.pushButtonCancel = None
self.showed = False
self.iface = None
self.oldCursorCtxt = None
self.isClosing_ = False
self.initFocusWidget_ = None
self.oldFormObj = None
self.accepted_ = False
if parent:
self.parent_ = QtGui.QWidget(parent)
else:
self.parent_ = QtGui.QWidget(pineboolib.project.mainWidget(), actionName, f)
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = None
elif cursor:
self.action_ = cursor.db().manager().action(actionName)
else:
self.action = FLSqlConnections.database().manager().action(actionName)
if self.action_:
self.name_ = self.action_.name()
def init1(self, actionName, parent=None):
self.setFocusPolicy(QtGui.QWidget.NoFocus)
if actionName.isEmpty():
self.action_ = False
print(
FLUtil.translate("app",
"FLFormSearchDB : Nombre de acción vacío"))
return
else:
self.action_ = FLSqlConnections.database().manager().action(
actionName)
if not self.action_:
print(
FLUtil.translate(
"app",
"FLFormSearchDB : No existe la acción %s" % actionName))
return
self.cursor_ = FLSqlCursor(self.action_.table(), True, "default", 0, 0,
self)
self.name_ = self.action_.name()
self.initForm()
def setMainWidgetString(self, uiFileName):
if self.cursor_:
self.setMainWidgetQWidget(self.cursor_.db().managerModules.createUI(uiFileName, self, self))
else:
self.setMainWidget(FLSqlConnections.database().managerModules().createUI(uiFileName, self, self))