$db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active'", "vState");
//$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;
$poad = isset($_SESSION['poadd']) ? $_SESSION['poadd'] : '';
$podtls = array();
$asocdtls = array();
$sorgdtls = array();
$invdl = array();
$poAttachments = array();
if ($view == 'edit') {
$podtls = $pohObj->select($iPurchaseOrderID);
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
if ($podtls[0]['iBuyerOrganizationID'] != $curORGID && $podtls[0]['iSupplierOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
} else {
if ($podtls[0]['iSupplierOrganizationID'] == $curORGID && $podtls[0]['iStatusID'] < $isdtls) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
}
}
$sorgdtls = $orgObj->select($podtls[0]['iSupplierOrganizationID']);
if ($podtls[0]['iInvoiceID'] > 0) {
$invdl = $invOrdObj->select($podtls[0]['iInvoiceID']);
}
}
$vldmsg = $validation->CreateHtmlMsg($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION']);
unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION']);
}
#### ENDS HERE ###
if ($sess_usertype_short == 'OU' && $poCreate != 'Yes') {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
}
$poad = isset($_SESSION['poadd']) ? $_SESSION['poadd'] : '';
// unset($_SESSION['poadd']);
if (trim($poid) != '' && is_numeric($poid)) {
$view = 'edit';
}
if ($view == 'edit') {
$podtls = $pohObj->select($poid);
$isdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isdtls = $isdtls[0]['iStatusID'];
if ($podtls[0]['iBuyerOrganizationID'] != $curORGID && $podtls[0]['iSupplierOrganizationID'] != $curORGID) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
} else {
if ($podtls[0]['iSupplierOrganizationID'] == $curORGID && $podtls[0]['iStatusID'] < $isdtls) {
header("Location: " . SITE_URL_DUM . "polist/all");
exit;
}
}
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Rejected' ");
$sts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Create'");
$crsts = $stsdtls[0]['iStatusID'];
$poLineObj->setAllVar($invItems);
$itm = $poLineObj->insert();
}
}
// mail
if ($po > 0) {
$sub1 = "Purchase Order Created";
$type = "Create";
$actn = "Create";
$sub2 = "New Purchase Order";
$dt['iItemID'] = $po;
$dt['eSubject'] = $sub1;
$dt['eType'] = $type;
$where = "AND vType='{$sub1}' AND eSection='Member'";
$db_email = $emailObj->getDetails('*', $where);
$invdt = $pohObj->select($po);
$orgpref = $orgprefObj->getStatusDetails($invdt[0]['iBuyerOrganizationID']);
$orginvstatus = $orgpref['po'];
$orgusrs = $orgUsrObj->getDetails('*', " AND iOrganizationID=" . $invdt[0]['iBuyerOrganizationID']);
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Rejected' ");
$rjtsts = $stsdtls[0]['iStatusID'];
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$acptsts = $stsdtls;
$lang = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'];
$stsdtls = $statusmasterObj->getDetails("*, vStatusMsg_{$lang} as vStatusMsg", " AND eFor='PO' AND vStatus_en='Issued' ");
$isusts = $stsdtls;
/* if($invdt[0]['iStatusID'] != $isusts[0]['iStatusID']) {
if(count($orgusrs) > 1 && $invdt[0]['iStatusID'] != $acptsts[0]['iStatusID'] ) {
for($l=0;$l<count($orginvstatus);$l++) {
$nxtlevel = '1';
if($invdt[0]['iStatusID'] == $orginvstatus[$l]['iStatusID']) {
$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']);
}
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='Invoice' AND vStatus_en='Rejected' ");
$rjtsts = $stsdtls[0]['iStatusID'];
if ($invdtls[0]['iStatusID'] == $rjtsts) {
$lang = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG'];
$msg = $stsdtls[0]['vStatusMsg_' . $lang];
} else {
if ($invdtls[0]['eSaved'] == 'Yes') {
$msg = $smarty->get_template_vars('LBL_SAVED');
} else {
if ($invad != 'yes') {
header("Location: " . SITE_URL_DUM . "invoiceview/{$iInvoiceID}");
exit;
}
}
if (trim($iInvoiceID) != '' && $iInvoiceID > 0) {
$dtls = $invOrdObj->select($iInvoiceID);
$bdtls = $bnkObj->select($dtls[0]['iBankId']);
if ($dtls[0]['iPurchaseOrderID'] != "" && $dtls[0]['iPurchaseOrderID'] != "0") {
$rfq2_dets = $rfq2Obj->getDetails('*', " AND iPurchaseOrderID = '" . $dtls[0]['iPurchaseOrderID'] . "' ");
if (count($rfq2_dets) > 0) {
$awrdtls = $rfq2awObj->getDetails('*', " AND iRFQ2Id='" . $rfq2_dets[0]['iRFQ2Id'] . "' ");
$bid_dtls = $rfq2bidObj->getDetails('*', " AND iBidId='" . $awrdtls[0]['iBidId'] . "' ");
$dtls[0]['fPOAwardAdvace'] = $bid_dtls[0]['fBidAdvanceTotal'];
$dtls[0]['fPOAwardPrice'] = $bid_dtls[0]['fBidPriceTotal'];
$dtls[0]['fPOAwardAmount'] = $bid_dtls[0]['fBidAmount'];
}
}
}
if (trim($iPurchaseOrderID) != '' && $iPurchaseOrderID > 0) {
$dtls = $purOrdObj->select($iPurchaseOrderID);
}
if (trim($iInvoiceID) != '' && $iInvoiceID > 0) {
?>
<input type="hidden" name="dNetPaymentdate" id="dNetPaymentdate" value="<?php
echo $dtls[0]['dNetPaymentdate'];
?>
" />
<label class="col-md-2 control-label"><?php
echo $smarty->get_template_vars('LBL_INV_CODE');
?>
</label>
<div class="col-md-4">
<a target="_blank" style="text-decoration:none; cursor:pointer;" onclick="openpopup('<?php
echo $SITE_URL_DUM . "invoiceview/" . $dtls[0]['iInvoiceID'] . "/pop";
?>
}
$redirecturl = SITE_URL . "index.php?file=u-purchaseorderadditems&id={$id}&msg={$msg}";
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg;
} else {
if ($view == 'verify') {
$eDelete = $_POST['edelete'];
$iPurchaseOrderID = $_POST['iPOID'];
if ($eDelete == 'Yes') {
$pohObj->delete($iPurchaseOrderID);
$msg = "rds";
$_SESSION['SESS_' . PRJ_CONST_PREFIX . '_MSG'] = $msg;
header("location:" . SITE_URL_DUM . 'polist/' . $msg);
exit;
}
$nstatus = $_POST['nstatus'];
$podtl = $pohObj->select($iPurchaseOrderID);
if ($totusrs > 1) {
$dt['iStatusID'] = $nstatus;
} else {
$stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
$isusts = $stsdtls[0]['iStatusID'];
if ($podtl[0]['iSupplierOrganizationID'] == $curORGID && $podtl[0]['iStatusID'] == $isusts) {
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$dt['iStatusID'] = $acptsts[0]['iStatusID'];
} else {
// $stsdtls = $statusmasterObj->getDetails('*'," AND eFor='PO' AND vStatus_en='Issued' ");
$dt['iStatusID'] = $isusts;
}
}
$dt['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
// prints($dt); exit;
<?php
include S_SECTIONS . "/member/memberaccess.php";
if (!isset($orgUserObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.OrganizationUser.php";
$orgUserObj = new OrganizationUser();
}
if (!isset($userToVerifyObj)) {
include_once SITE_CLASS_APPLICATION . 'user/class.OrganizationUserToverify.php';
$userToVerifyObj = new OrganizationUserToverify();
}
if (!isset($orgObj)) {
include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php";
$orgObj = new Organization();
}
if (!isset($pohObj)) {
include_once SITE_CLASS_APPLICATION . "user/class.PurchaseOrderHeading.php";
$pohObj = new PurchaseOrderHeading();
}
$iPoId = GetVar('id');
$podtls = $pohObj->select($iPoId);
$pohistory = $pohObj->getHistory($iPoId, $curORGID);
// ,$curORGID
// prints($pohistory); exit;
$smarty->assign('podtls', $podtls);
$smarty->assign('pohistory', $pohistory);
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();
}
// pr($_POST); exit;
$iPurchaseOrderID = $poid;
$acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
$invdt = $pohObj->select($iPurchaseOrderID);
// prints($invdt); 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'");
if (is_array($smdt) && is_array($ordt)) {
$emailArr = array_merge($smdt, $ordt);
} else {
if (is_array($smdt)) {
$emailArr = $smdt;
} else {
if (is_array($ordt)) {
$emailArr = $ordt;
}
