$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; }