$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#");
