$item => '' $item_name => '' $account_plan => '' if ($item eq "product") { } #cargo el own-pos entity id callTrigger('searchOwnPosData') callTrigger('startWaitingModeTrigger') import gnue.common.GConditions as GConditions import string import hack import printing table = [] table.append (printing.printDate ()) line = "\n\nListado de Productos\n\n\n" table.append(line) line = " | "+printing.printTitle("Código",13)+" | " line += printing.printTitle("Nombre",48)+" | " line += printing.printTitle("Stock",8)+" | " lineLen = len(line) table.append(line) line = "" for idx in range(lineLen): line += "-" table.append(line) productCondition = GConditions.GConditions() tmpAnd = GConditions.GCand(productCondition) if str(productSearchBlock.searchCodeEntry) or str(productSearchBlock.searchNameEntry): if str(productSearchBlock.searchCodeEntry): eq1 = GConditions.GClike(tmpAnd) GConditions.GCField(eq1,"_product_code_data.code") GConditions.GCConst(eq1,str(productSearchBlock.searchCodeEntry)+'%') if str(productSearchBlock.searchNameEntry): eq2 = GConditions.GClike(tmpAnd) GConditions.GCField(eq2,"_product_data.name") GConditions.GCConst(eq2,str(productSearchBlock.searchNameEntry)+'%') tmpOr = GConditions.GCor(tmpAnd) eq3 = GConditions.GClike(tmpOr) GConditions.GCField(eq3,"_product_store_data.storehouse") GConditions.GCConst(eq3,str(ownStorehouseBlock.ownStorehouseIdEntry)) tmpNull = GConditions.GCnull(tmpOr) GConditions.GCField(tmpNull,"_product_store_data.storehouse") productResulSet = printProductDataSource.createResultSet(productCondition) more = productResulSet.firstRecord(); while more: line = " | "+printing.printField(productResulSet.current.getField("_product_code_data.code"),13,'l')+" | " line += printing.printField(productResulSet.current.getField("_product_data.canonical_name"),48,'l')+" | " if productResulSet.current.getField("_product_store_data.level"): line += printing.printField("%0.2f" % productResulSet.current.getField("_product_store_data.level"),8,'r')+" | " else: line += printing.printField("0.00",8,'r')+" | " table.append(line) more = productResulSet.nextRecord() callTrigger('endWaitingModeTrigger') printing.previewPrint(table) 0 and not productResultBlock.getCurrentRecord().isEmpty(): productBlock.initQuery() productBlock.productIdEntry = ("%s" % productResultBlock.productIdREntry) productBlock.processQuery() productResultBlock.reset() ]]> if ($item eq "product") { } else { } if ($item eq "product") { }