}
         } else {
             $Data['iSubQuantity'] = 0;
             $Data['fSubRate'] = 0;
             $Data['fSubAmount'] = 0;
         }
     }
 }
 if ($Data['fLineTotal'] <= 0) {
     // $Data['fAmount']<=0 ||
     continue;
 }
 // echo $view;
 // prints($Data); // exit;
 if ($view == '' || $view == 'add') {
     $ilineItemCode[] = $vItmCode = $poLineObj->getUniqueCode();
     $Data['vItemCode'] = $vItmCode;
     $vPOItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10");
     $Data['iLineNumber'] = $vPOItemLineNumber;
     $Data['dETA'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
     $poLineObj->setAllVar($Data);
     $id = $poLineObj->insert();
     if ($id) {
         $msg = "ras";
     } else {
         $msg = "raserr";
     }
 } else {
     if ($view == 'edit') {
         $podtls = $poLineObj->getDetails('*', " AND vItemCode='" . $Data['vItemCode'] . "'");
         if (count($podtls) > 0 && is_array($podtls)) {
示例#2
0
     $po = $pohObj->insert();
     $poitems = $invLineObj->getDetails('*', " AND iInvoiceID={$iInvoiceID}");
     // prints($poitems); exit;
     for ($l = 0; $l < count($poitems); $l++) {
         $invItems = $poitems[$l];
         $invItems['iRelatedInvoiceLineID'] = $invItems['iInvoiceLineID'];
         unset($invItems['iInvoiceLineID']);
         unset($invItems['dCreatedDate']);
         unset($invItems['iRelatedPurchaseOrderLineID']);
         // $vItemCode = $invItems['vItemCode'];
         // prints($vItemCode); exit;
         // $invitmdtl = $invLineObj->getDetails('*'," AND vItemCode=$vItemCode");
         /* if(count($invitmdtl) > 0) {
            $vItemCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_invoice_detail_line","vItemCode");
            } */
         $vItemCode = $poLineObj->getUniqueCode();
         $vPOItemLineNumber = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10");
         $invItems['vItemCode'] = $vItemCode;
         $invItems['iLineNumber'] = $vPOItemLineNumber;
         $invItems['dETA'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
         $invItems['iPurchaseOrderID'] = $po;
         // prints($invItems); exit;
         $poLineObj->setAllVar($invItems);
         $itm = $poLineObj->insert();
     }
 }
 // mail
 if ($po > 0) {
     $sub1 = "Purchase Order Created";
     $type = "Create";
     $actn = "Create";
示例#3
0
             $it = 0;
             foreach ($itemTagArr as $itemkey1 => $itemval1) {
                 if ($type == '.xml') {
                     $itemkey1 = strtolower(str_replace(" ", "", $itemkey1));
                     $Data_item[$itemval1] = trim($itemvals[$itemkey1]);
                 } else {
                     $Data_item[$itemval1] = trim($itemvals[$it]);
                 }
                 $it++;
             }
             if ($enc == 'y') {
                 foreach ($Data_item as $k => $v) {
                     $Data_item[$k] = $encobj->mdecrypt($v);
                 }
             }
             $itmCode = $poLineObj->getUniqueCode();
             $Data_item['vItemCode'] = $itmCode;
             $Data_item['dETA'] = date('Y-m-d H:i:s');
             $Data_item['iPurchaseOrderID'] = $id;
             $Data_item['iLineNumber'] = $generalobj->UniqueID("", PRJ_DB_PREFIX . "_purchase_order_line", "iLineNumber", $charlimit = "10");
             $poLineObj->setAllVar($Data_item);
             $dupit = $poLineObj->chkDuplicate('iLineNumber', $Data_item);
             if ($dupit > 0) {
                 $id_items = $poLineObj->updateData($Data_item, " iOrderLineID = {$dupit} ");
                 $id_items = $dupit;
             } else {
                 $id_items = $poLineObj->insert();
             }
         }
     }
 }