}
if (!isset($orgprefObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreference.php";
$orgprefObj = new OrganizationPreference();
}
if (!isset($poAttachmentObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderAttachment.php";
$poAttachmentObj = new PurchaseOrderAttachment();
}
if (!isset($invOrdObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOrderHeading.php";
$invOrdObj = new InvoiceOrderHeading();
}
if (!isset($invprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOtherInformation.php";
$invprefObj = new InvoiceOtherInformation();
}
$mmsg = '';
$msg = $_GET['msg'];
/*if($msg == 'ras') {
$msg = $smarty->get_template_vars('MSG_ADD_SUCC');
} elseif($msg == 'raserr') {
$msg = $smarty->get_template_vars('MSG_ADD_ERR');
} elseif($msg == 'tmm') {
$mmsg = $smarty->get_template_vars('LBL_PO_TOTAL_MISMATCH');
} else{ $msg=''; }*/
$UserName = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_NAME'];
//$msg=$_REQUEST['msg'];
if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] != '') {
$msg = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'];
unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG']);
}
if (!isset($userActionObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.UserActionVerification.php';
$userActionObj = new UserActionVerification();
}
if (!isset($sendMail)) {
include SITE_CLASS_GEN . "class.sendmail.php";
$sendMail = new SendPHPMail();
}
if (!isset($imgObj)) {
include_once SITE_CLASS_GEN . "class.imagecrop.php";
$imgObj = new imagecrop();
}
if (!isset($ioprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOtherInformation.php";
$ioprefObj = new InvoiceOtherInformation();
}
$Data = $_POST['Data'];
$eFrom = $Data['eFrom'];
unset($Data['eFrom']);
$iInvoiceID = $_POST['iInvoiceID'];
$Data['iInvoiceID'] = $iInvoiceID;
//prints($_POST); exit;
$ioextdtls = $ioprefObj->getDetails("*", " AND iInvoiceID={$iInvoiceID} ");
// prints($ioextdtls); exit;
if (is_array($ioextdtls) && count($ioextdtls) > 0) {
$rs = $ioprefObj->updateData($Data, "iInvoiceID={$iInvoiceID}");
$msg = "rus";
} else {
$rs = $ioprefObj->insert($Data);
$msg = "ras";
}
if (!isset($orgUserPermObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUserPermission.php";
$orgUserPermObj = new OrganizationUserPermission();
}
if (!isset($pohObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$pohObj = new PurchaseOrderHeading();
}
if (!isset($statusmasterObj)) {
include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php";
$statusmasterObj = new StatusMaster();
}
if (!isset($invprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOtherInformation.php";
$invprefObj = new InvoiceOtherInformation();
}
$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.*, (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'];
if (!(is_array($invoiceData) && count($invoiceData) > 0)) {
header("Location: " . SITE_URL_DUM . "invoicelist");
$orgprefObj = new OrganizationPreference();
}
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
$arr_loaded_ext = get_loaded_extensions();
if (in_array('mcrypt', $arr_loaded_ext)) {
if (!isset($encobj)) {
require_once SITE_CLASS_GEN . "class.encryption.php";
$encobj = new Encryption();
}
}
if (!isset($ioprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOtherInformation.php";
$ioprefObj = new InvoiceOtherInformation();
}
$row = 1;
//$type = $_POST['type'];
//$type = 'xml';
$img_file = $_FILES['importfile'];
$fileName = $imgObj->UploadFile('IMPORT_FILES_PATH', 'file', '', $img_file, $OldImg);
$fileType = substr($fileName, -4);
//$fileurl = $cfgimg['IMPORT_FILES_PATH']['file']['url']."/".$fileName;
$fileurl = $cfgimg['IMPORT_FILES_PATH']['file']['url'] . $fileName;
$filepath = $cfgimg['IMPORT_FILES_PATH']['file']['path'] . $fileName;
$type = $fileType;
if ($type == ".jpg" || $type == "jpeg" || $type == ".png" || $type == ".gif" || $type == ".bmp") {
$Data['dCreatedDate'] = $Data['dIssueDate'] = date('Y-m-d H:i:s');
$Data['vFromIP'] = $_SERVER['REMOTE_ADDR'];
$Data['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
}
if (!isset($imgObj)) {
include_once SITE_CLASS_GEN . "class.imagecrop.php";
$imgObj = new imagecrop();
}
if (!isset($poAttachmentObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderAttachment.php";
$poAttachmentObj = new PurchaseOrderAttachment();
}
if (!isset($poprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PoOtherInformation.php";
$poprefObj = new PoOtherInformation();
}
if (!isset($ioprefObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.InvoiceOtherInformation.php";
$ioprefObj = new InvoiceOtherInformation();
}
$poisu = $statusmasterObj->getDetails('iStatusID', " AND eFor='PO' AND (vStatus_en='Auth1' || vStatus_en='Auth2' || vStatus_en='Auth3') ");
// prints($poisu); exit;
$totusrs = $orgUsrObj->getDetails(" COUNT(*) as tot ", " AND iOrganizationID={$curORGID} AND eUserType='User'");
$totusrs = $totusrs[0]['tot'];
$ordt = $orgUsrObj->getDetails('*', " AND iOrganizationID={$curORGID} AND eUserType='Admin' AND eStatus='Active'");
$org = $orgObj->select($curORGID);
$smdt = $secManObj->getDetails('*', " AND iASMID=" . $org[0]['iASMID'] . " AND eStatus='Active'");
// $jtbl = " LEFT JOIN b2b_organization_user_permission up on ou.iUserID=up.iUserID ";
// $usreml = $orgUsrObj->getJoinTableInfo($jtbl,'*'," AND ou.iOrganizationID=$curORGID AND ou.iUserID!=$sess_id AND ou.eUserType='User' AND ou.eStatus='Active' AND (up.tPermission LIKE '%po:%".$poisu[0]['iStatusID']."%' OR up.tPermission LIKE '%po:%".$poisu[1]['iStatusID']."%' OR up.tPermission LIKE '%po:%".$poisu[2]['iStatusID']."%')");
// prints($usreml); exit;
if (is_array($smdt) && is_array($ordt)) {
$emailArr = array_merge($smdt, $ordt);
} else {
if (is_array($smdt)) {
