$code[] = $orgdt[0]['dCreatedDate'];
//
$iv_val = $encobj->setEncValues($encKey, $encAlgo, $code, '');
}
}
//}
// $limit = " LIMIT ".($page-1)*$REC_LIMIT_FRONT.", ".$REC_LIMIT_FRONT." ";
// print $where;
// and poh.iStatusID in (".$poUserStatusIds.")
$orderBy = " ioh.iInvoiceID ";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on sm.iStatusID = ioh.iStatusID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user ou on ou.iUserID = ioh.iBuyerID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on poh.iPurchaseOrderID = ioh.iPurchaseOrderID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_invoice_otherinformation ioi on ioh.iInvoiceID=ioi.iInvoiceID ";
$fields = " ioh.*,sm.vStatus_" . LANG . " as status,CONCAT(ou.vFirstName,' ',ou.vLastName) as buyername, DATEDIFF(NOW(),ioh.dCreatedDate) as days,DATE_FORMAT(ioh.dIssueDate,'%Y-%m-%d') as dIssueDate,poh.vPONumber,poh.dCreateDate as podate,\r\n\t\t\t\tioi.tSourcingDocument, ioi.tGlobalAgreement, ioi.tPaymentTerms, ioi.tFOB, ioi.tDeliveryTerms, ioi.tShippingControl, ioi.tConditionsForPayment, ioi.tPenalties, ioi.tSpecialInstruction, ioi.tNote ";
$ExportArr = $poObj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, '', $limit, 'yes');
$ExportArr = array_slice($ExportArr, 0, -1);
// prints($ExportArr);exit;
$sep = "\t,";
$down_tools = 'INVOICE';
// GET USER PROJECT MEMBER PERMISSION DETAIL
switch ($down_tools) {
case 'INVOICE':
$xmlArr = array('Header' => 'invoices', 'Arr' => $ExportArr);
$TagArr = array('Supplier Company Name' => 'vSupplierName', 'Supplier Company ID' => 'iSupplierOrganizationID', 'Supplier Code' => 'vInvoiceSupplierCode', 'Invoice Supplier Code' => 'vInvSupplierCode', 'Related PO Code ' => 'vExtPOCode', 'Buyer Name' => 'vBuyerName', 'Buyer ID' => 'iBuyerOrganizationID', 'Buyer Contact Party ' => 'vBuyerContactParty', 'Invoice Code' => 'vInvoiceCode', 'Issue Date' => 'dIssueDate', 'Invioce Description' => 'tInvoiceDescription', 'Opening Unit' => 'iOpeningUnit', 'Supplier Order Num' => 'vSupplierOrderNum', 'Invoice Type' => 'eInvoiceType', 'Line Item Tax' => 'eLineItemTax', 'VAT' => 'fVAT', 'Other tax 1' => 'fOtherTax1', 'Freight' => 'vFreight', 'Miscellaneous' => 'tMiscellaneous', 'Discount Baseline' => 'dCashDiscountBaseline', 'Max Cash Discount Days' => 'iMaxCashDiscountDays', 'Max Cash Discount Percentage' => 'fMaxCashDiscountPercentage', 'Normal Cash Discount Days ' => 'iNormalCashDiscountDays', 'Normal Cash Discount Percentage' => 'iNormalCashDiscountPercentage', 'Bill To Party' => 'vBillToParty', 'Bill To AddLine 1' => 'vBillToAddLine1', 'Bill To AddLine 2' => 'vBillToAddLine2', 'Bill To City' => 'vBillToCity', 'Bill To Country' => 'vBillToCountry', 'Bill To State' => 'vBillToState', 'Bill To ZipCode' => 'vBillToZipCode', 'Bill To Contact Party' => 'vBillToContactParty', 'Bill To Contact Telephone' => 'vBillToContactTelephone', 'Currency' => 'vCurrency', 'Invoice Total' => 'fInvoiceTotal', 'Prepayment' => 'fPrePayment', 'Sourcing Document' => 'tSourcingDocument', 'Global Agreement' => 'tGlobalAgreement', 'Payment Terms' => 'tPaymentTerms', 'FOB' => 'tFOB', 'Delivery Terms' => 'tDeliveryTerms', 'Shipping Control' => 'tShippingControl', 'Conditions For Payment' => 'tConditionsForPayment', 'Penalties' => 'tPenalties', 'Special Instruction' => 'tSpecialInstruction', 'Note' => 'tNote');
/*foreach($TagArr as $key=>$arr){
$ss.= ''.$key.',';
}
echo $ss;exit;
*/
$repeat = array('CallFunc' => '$poObj->GetInvoiceItems', 'VariablePass' => 'iInvoiceID', 'repeatcsv' => 'Order Type,Item Description,Item Line No,Quantity,Unit Of Measure,Price,Amount,VAT,Other Tax,Sub Item Type,Sub Item Quantity,Sub Item Rate,Sub Item Amount,Line Total', 'Header' => 'items', 'XmlTagArr' => array('Order Type' => 'eInvoiceType', 'Item Description' => 'tDescription', 'Item Line No' => 'iLineNumber', 'Quantity' => 'iQuantity', 'Unit Of Measure' => 'vUnitOfMeasure', 'Price' => 'fPrice', 'Amount' => 'fAmount', 'VAT' => 'fVAT', 'Other Tax' => 'fOtherTax1', 'Sub Item Type' => 'eSublineType', 'Sub Item Quantity' => 'iSubQuantity', 'Sub Item Rate' => 'fSubRate', 'Sub Item Amount' => 'fSubAmount', 'Line Total' => 'fLineTotal'));
} else {
$cursort_type = 'DESC';
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " ioh.dCreatedDate DESC ";
}
## ENDS HERE ###
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
// echo $where;
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on ioh.iPurchaseOrderID=poh.iPurchaseOrderID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on (IF(ioh.iBuyerOrganizationID={$curORGID},sm.iStatusID = ioh.iaStatusID,sm.iStatusID = ioh.iStatusID))";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user ou on ou.iUserID = ioh.iBuyerID";
// echo $where; exit;
$fields = " ioh.*,ioh.vInvoiceNumber,ioh.vInvoiceCode,ioh.fInvoiceTotal,sm.vStatus_" . LANG . " as status,CONCAT(ou.vFirstName,' ',ou.vLastName) as buyername, DATEDIFF(NOW(),ioh.dCreatedDate) as days ";
$activegroup = $invOrdderObj->getJoinTableInfo($jtbl, $fields, $where, $orderBy, '', $limit, 'yes');
// prints($activegroup);exit;
//$orglist = $orgGroupObj->getDetails_PG('*',$where,$orderBy,'',$limit);
$count = $activegroup['tot'];
unset($activegroup['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
$pgajxobj = new Paging($count, $page, "listgroup", $REC_LIMIT_FRONT);
}
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
//echo $paging; exit;
$smarty->assign('activegroup', $activegroup);
//$smarty->assign('orglist',$orglist);
$smarty->assign('isusts', $isusts);
$smarty->assign('count', $count);
}
if (!isset($orgUserObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.OrganizationUser.php';
$orgUserObj = new OrganizationUser();
}
$sess_user_name = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_NAME'];
$sess_usertype_short = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
if (!isset($userActionObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php';
$userActionObj = new UserActionVerification();
}
if ($mode == 'delete') {
$where = "AND iInvoiceID IN ({$val})";
//$fields="ioh.*,(select org.vCompanyName from b2b_organization_master org where org.iOrganizationID=ioh.iBuyerOrganizationID) as vBuyerName";
$fields = "*";
$arr = $invObj->getJoinTableInfo("", $fields, $where);
$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'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$invObj->setAllVar($data);
$where = "iInvoiceID IN (" . $v['iInvoiceID'] . ")";
$res = $invObj->updateData($data, $where);
$link = SITE_URL_DUM . "invoiceview/" . $v['iInvoiceID'];
$INVCODE = $v['vInvoiceCode'];
$pohObj = new PurchaseOrderHeading();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
$crtsts = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Create' ");
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Rejected' ");
$rjtsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Accepted' ");
$acptsts = $stsdtls;
$lang = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'];
$stsdtls = $statusmasterObj->getDetails("*, vStatusMsg_{$lang} as vStatusMsg", " AND eFor='Invoice' AND vStatus_en='Issued' ");
$isusts = $stsdtls;
$fields = " ioh.*, ioh.vExtPOCode, (select vState from b2b_state_master sm where BINARY sm.vStateCode=ioh.vBillToState AND BINARY sm.vCountryCode=ioh.vBillToCountry) as vBillToState,\r\n\t\t\t\t(select vCountry from b2b_country_master cm where BINARY cm.vCountryCode=ioh.vBillToCountry) as vBillToCountry\t";
$invoiceData = $invOrderObj->getJoinTableInfo('', $fields, " AND iInvoiceID={$iInvoiceID} ");
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
// pr($_SESSION); exit;
if (!(is_array($invoiceData) && count($invoiceData) > 0)) {
header("Location: " . SITE_URL_DUM . "invoicelist");
exit;
}
if ($uorg_type == 'Buyer2') {
$b2us = $invOrderObj->getInvoiceRfq2Buyer2OrgIds($iInvoiceID);
if (!in_array($curORGID, $b2us)) {
header("Location: " . SITE_URL_DUM . "invoicelist");
exit;
}
} else {
if ($invoiceData[0]['iBuyerOrganizationID'] != $curORGID && $invoiceData[0]['iSupplierOrganizationID'] != $curORGID) {
#### ENDS HERE ###
// prints($vldmsg); exit;
*/
//$sql="select vOrganizationCode, vCompanyName from b2b_organization_master org,b2b_organization_user user where org.iOrganizationId=user.iOrganizationId and user.vUserName='******'";
//$sql="select vOrganizationCode, vCompanyName from b2b_organization_master org where org.iOrganizationId=$curORGID";
//$res=$dbobj->MySqlSelect($sql); //$curORGID
$orgdtls = $orgObj->select($curORGID);
$orgname = $orgdtls[0]['vCompanyName'];
$OrgCode = $orgdtls[0]['vOrganizationCode'];
// prints($orgname);exit;
$invdtls = array();
if ($view == 'edit') {
// $invdtls = $invOrdObj->select($iInvoiceID);
$fields = " ioh.*, poh.vPOCode ";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on ioh.iPurchaseOrderID=poh.iPurchaseOrderID ";
$invdtls = $invOrdObj->getJoinTableInfo($jtbl, $fields, " AND ioh.iInvoiceID={$iInvoiceID} ");
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
if ($invdtls[0]['iBuyerOrganizationID'] != $curORGID && $invdtls[0]['iSupplierOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "invoicelist/all");
exit;
} else {
if ($invdtls[0]['iBuyerOrganizationID'] == $curORGID && $invdtls[0]['iStatusID'] < $isdtls && $invdtls[0]['eCreateByBuyer'] != 'Yes') {
// && ! ($invdtls[0]['eCreateByBuyer']=='Yes' && ($invdtls[0]['iaStatusID']==0 || $invdtls[0]['iStatusID']==$rjtsts) )
header("Location: " . SITE_URL_DUM . "invoicelist/all");
exit;
}
}
$borgdtls = $orgObj->select($invdtls[0]['iBuyerOrganizationID']);
if ($invdtls[0]['iPurchaseOrderID'] > 0) {
$podl = $pohObj->select($invdtls[0]['iPurchaseOrderID']);
}
$orderBy = " {$cursort} {$cursort_type}";
} else {
$orderBy = " ioh.dCreatedDate DESC ";
}
## ENDS HERE ###
$limit = " LIMIT " . ($page - 1) * $REC_LIMIT_FRONT . ", " . $REC_LIMIT_FRONT . " ";
// $where .= " AND ioh.iStatusID>=$isusts "; // AND ioh.iaStatusID!=$rsts
$where .= " AND (ioh.iStatusID>={$isusts} OR ioh.iaStatusID={$rsts}) ";
$where = $where . $whr;
// echo $where;
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_purchase_order_heading poh on ioh.iPurchaseOrderID=poh.iPurchaseOrderID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_status_master sm on sm.iStatusID = ioh.iaStatusID";
$jtbl .= " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_user ou on ou.iUserID = ioh.iBuyerID";
// echo $where; exit;
$activegroup = $invOrdderObj->getJoinTableInfo($jtbl, "ioh.*,ioh.vInvoiceNumber,ioh.vInvoiceCode,ioh.fInvoiceTotal,sm.vStatus_" . LANG . " as status,CONCAT(ou.vFirstName,' ',ou.vLastName) as buyername", $where, $orderBy, '', $limit, 'yes');
// prints($activegroup);exit;
//$orglist = $orgGroupObj->getDetails_PG('*',$where,$orderBy,'',$limit);
$count = $activegroup['tot'];
unset($activegroup['tot']);
if (!isset($pgajxobj)) {
require_once SITE_CLASS_GEN . "class.paging-ajax.php";
$pgajxobj = new Paging($count, $page, "listgroup", $REC_LIMIT_FRONT);
}
$paging = $pgajxobj->getListPG($page);
$pgmsg = $pgajxobj->setMessage("Records");
//echo $paging; exit;
$smarty->assign('curORGID', $curORGID);
$smarty->assign('activegroup', $activegroup);
//$smarty->assign('orglist',$orglist);
$smarty->assign('count', $count);
// --- Invoice Order -----------------------------------------------------------------------------
/*$jtbl = " LEFT JOIN ".PRJ_DB_PREFIX."_organization_master org on ioh.iSupplierID=org.iOrganizationID
LEFT JOIN ".PRJ_DB_PREFIX."_state_master st on org.vState=st.vStateCode
LEFT JOIN ".PRJ_DB_PREFIX."_country_master cnt on org.vCountry=cnt.vCountryCode
";*/
$groupby = " ";
$fields = " *, ioh.dCreatedDate as addDate , (select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=ioh.iBuyerOrganizationID ) as buyerorg ";
if ($orgtype == 'Buyer') {
$icndt = " AND ioh.iBuyerOrganizationID={$orgid} AND ioh.iaStatusID>={$invisu} AND ioh.iaStatusID!={$invrjt} ";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on (ioh.iBuyerOrganizationID=org.iOrganizationID)\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_state_master st on org.vState=st.vStateCode\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cnt on org.vCountry=cnt.vCountryCode\r\n\t\t\t\t";
} else {
//if($orgtype == 'Supplier') {
$icndt = " AND ioh.iSupplierOrganizationID={$orgid} OR (ioh.iBuyerOrganizationID={$orgid} AND ioh.iaStatusID>={$invisu} AND ioh.iaStatusID!={$invrjt}) ";
$jtbl = " LEFT JOIN " . PRJ_DB_PREFIX . "_organization_master org on (ioh.iSupplierOrganizationID=org.iOrganizationID)\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_state_master st on org.vState=st.vStateCode\r\n\t\t\t\t LEFT JOIN " . PRJ_DB_PREFIX . "_country_master cnt on org.vCountry=cnt.vCountryCode\r\n\t\t\t\t";
}
$latestio = $invordheadingObj->getJoinTableInfo($jtbl, $fields, $icndt, " ioh.dCreatedDate DESC ", ' ioh.iInvoiceID ', " LIMIT 0,2");
$tot_latestio = isset($latestio['tot']) ? $latestio['tot'] : "";
//prints($latestio); exit;
unset($latestio['tot']);
$smarty->assign("latestio", $latestio);
$smarty->assign("tot_latestio", $latestio);
// -----------------------------------------------------------------------------------------------------------
// prints($orgbyusrvrfy); exit;
$oadDetail = $orgUserObj->getDetails('tDashboard', ' AND iUserID = "' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . '" ', '', '', '');
$tDashboard = $oadDetail[0]['tDashboard'];
$smarty->assign("tDashboard", $tDashboard);
// --- Buyer2 Associations -----------------------------------------------------------------------------
if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && ($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] == 'Buyer' || $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] == 'Both')) {
$b2by_dtls = $generalobj->getTableInfo(" " . PRJ_DB_PREFIX . "_buyer2_buyer_association b2ba ", " AND b2ba.iBuyerId={$curORGID} ", "b2ba.*, (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2ba.iBuyer2Id) as vBuyer2,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t (Select vCompanyName from " . PRJ_DB_PREFIX . "_organization_master where iOrganizationID=b2ba.iBuyerId) as vBuyer", " LIMIT 0,1 ", " ORDER BY iAssociationId DESC ", "");
$smarty->assign("b2by_dtls", $b2by_dtls);
//
