$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Create' "); } else { $stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' "); } $Data['iStatusID'] = $stsdtls[0]['iStatusID']; } //$vPONumber = $generalobj->UniqueID("PO",PRJ_DB_PREFIX."_purchase_order_heading","vPONumber",$charlimit="7"); // $vPOCode = $generalobj->UniqueID("PO",PRJ_DB_PREFIX."_purchase_order_heading","vPOCode",$charlimit="10"); $vPOCode = $pohObj->getUniqueCode(); $Data['vPOCode'] = $vPOCode; $vPONumber = "PO" . $Data['vPOCode'] . "-" . trim($Data['vBuyerCode']); $Data['vPONumber'] = $vPONumber; $Data['eDelete'] = 'No'; $dOrderDate = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $Data['dOrderDate'] = $dOrderDate; $pohObj->setAllVar($Data); $id = $pohObj->insert(); if ($id) { $files = $_FILES['files']; $titles = $_POST['titles']; $descprtiption = $_POST['descriptions']; $dAdate = calcGTzTime(date('Y-m-d'), 'Y-m-d'); if (trim($files['name'][0]) == '') { unset($files['name'][0]); } $fileData['iPurchaseOrderID'] = $id; $fileData['eRelatedTo'] = 'PO'; $fileData['dAdate'] = $dAdate; $fileUpload = array(); for ($i = 0; $i < count($files['name']); $i++) { // $fileData['vTitle']=$titles[$i];
$invdt['iStatusID'] = '0'; } else { if(trim($postatus) != '') { $postatus = @explode(',',$postatus); sort($postatus); $invdt['iStatusID'] = $postatus[0]; } } */ $pcstsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Create' "); $invdt['iStatusID'] = $pcstsdtls[0]['iStatusID']; /* } else { $poisusts = $statusmasterObj->getDetails('*'," AND eFor='PO' AND vStatus_en='Issued' "); $invdt['iStatusID'] = $poisusts[0]; } */ // prints($invdt); exit; $pohObj->setAllVar($invdt); $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"); } */
if ($mode == 'delete' || $mode == 'deleteall') { $where = "AND iPurchaseOrderID IN ({$val})"; $fields = "poh.*,(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=poh.iSupplierOrganizationID) as vSupplierName"; $arr = $poObj->getJoinTableInfo("", $fields, $where); //prints($arr);exit; $userId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $orgId = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGID']; $where = " AND iOrganizationID='{$orgId}'"; $emailArr = $orgUserObj->getDetails('vFirstName,vLastName,vEmail', $where); $where = ""; foreach ($arr as $k => $v) { $data['eDelete'] = 'Yes'; $data['iModifiedByID'] = $userId; // $data['eModifiedBy'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT']; // $data['dModifiedDate'] = date('Y-m-d H:i:s'); $poObj->setAllVar($data); $where = "iPurchaseOrderID IN (" . $v['iPurchaseOrderID'] . ")"; $res = $poObj->updateData($data, $where); $link = SITE_URL_DUM . "purchaseorderview/" . $v['iPurchaseOrderID']; $POCODE = $v['vPOCode']; $PONUMBER = $v['vPONumber']; $SUPPLIER = $v['vSupplierName']; if ($SUPPLIER == '') { $SUPPLIER = "---"; } $BUYER = $v['vBuyerCompanyName']; $where = "AND vType='PO Deleted' AND eSection='Member'"; $db_email = $emailObj->getDetails('*', $where); $body = array("#DELETE_BY#", "#PONUMBER#", "#POCODE#", "#SUPPLIER#", "#BUYER#", "#LINK#"); $post = array($sess_user_name . "({$sess_usertype_short})", $PONUMBER, $POCODE, $SUPPLIER, $BUYER, $link); $rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");