$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']); } $asocdtls = $asocObj->getDetails('*', " AND iBuyerOrganizationID={$curORGID} AND iSupplierAssocationID=" . $podtls[0]['iSupplierOrganizationID']); $poAttachments = $poAttachmentObj->getDetails('*', ' AND iPurchaseOrderID="' . $iPurchaseOrderID . '"'); $stsdtls = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Rejected' "); $rjtsts = $stsdtls[0]['iStatusID']; if ($podtls[0]['iStatusID'] == $rjtsts) { if ($podtls[0]['iSupplierOrganizationID'] == $curORGID) { header("Location: " . SITE_URL_DUM . "purchaseorderview/{$iPurchaseOrderID}"); exit; } $lang = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_LANG']; $msg = $stsdtls[0]['vStatusMsg_' . $lang]; } else { if ($podtls[0]['eSaved'] == 'Yes') { $msg = $smarty->get_template_vars('LBL_SAVED'); } else { if ($poad != 'yes') {
if (trim($orgcode) != '') { $where .= " AND vOrganizationCode LIKE '{$orgcode}%'"; $ISSEARCHED = 'Yes'; } $orgname = isset($orgname) ? $orgname : ''; if (trim($orgname) != '') { $where .= " AND vCompanyName LIKE '%{$orgname}%'"; $ISSEARCHED = 'Yes'; } $whr = isset($whr) ? $whr : ''; if (trim($asocCode) != '') { $whr .= " AND vAssociationCode!='{$asocCode}'"; } // $where .= " AND eOrganizationType !='Buyer' AND iOrganizationID!=$iBuyerOrganizationID"; $where .= " AND eOrganizationType NOT IN ('Buyer','Buyer2') AND iOrganizationID!={$iBuyerOrganizationID}\r\n AND iOrganizationID NOT IN (Select iSupplierAssocationID from " . PRJ_DB_PREFIX . "_organization_association where iBuyerOrganizationID={$iBuyerOrganizationID}) "; $sellerorgs = $orgAssocObj->getDetails('iSupplierAssocationID', " AND iBuyerOrganizationID={$iBuyerOrganizationID} {$whr} "); // prints($asocCode); exit; /*$slorgs = $orgAssocObj->getDetails('iSupplierAssocationID'," AND iBuyerOrganizationID=$iBuyerOrganizationID AND (eStatus='Need to Verify' || eStatus='Modified' || eStatus='Delete' || eNeedToVerify='Yes') "); // AND (eStatus='Active' AND eNeedToVerify='No') foreach($slorgs as $k=>$v) { $starr[] = $v['iSupplierAssocationID']; } if(is_array($slorgs) && count($slorgs)>0) { $islorgs = @implode(',',$starr); } else if(trim($slorgs[0]['iSupplierAssocationID']) != '') { $islorgs = $slorgs[0]['iSupplierAssocationID']; } // echo $islorgs; exit; */ if (is_array($sellerorgs)) {
// pr($data); exit; // if(count($emlar) > 0){ $data['eStatus'] = 'Need to Verify'; /*}else{ $data['eStatus'] = 'Active'; }*/ ### CHECK MULTIPLE ADMIN AVAILABLE FOR THIS ORGANIZATION OR NOT /*$chkMulAdmin = $orgObj->ChkMultipleOrgAdmin(); if($chkMulAdmin == '1'){ $data['eStatus'] = 'Active'; }else{ $data['eStatus'] = $data['eStatus']; }*/ $asoc_ary = array(); //$assarr = $orgAssocObj->getDetails('*'," AND iBuyerOrganizationID=$iBuyerOrganizationID",'iAsociationID Asc','',''); $assarr = $orgAssocObj->getDetails('*', " AND vAssociationCode='" . $vAssociationCode . "'", ' iSupplierAssocationID Asc ', '', ''); for ($l = 0; $l < count($assarr); $l++) { $asoc_ary[] = $assarr[$l]['iSupplierAssocationID']; $asocd[$assarr[$l]['iSupplierAssocationID']] = $assarr[$l]; } // prints($assarr);exit; // prints($_POST);exit; // echo $view; exit; if ($view == 'reject') { $reasonToReject = $_POST['tReasonToReject']; $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = 'No'; $dt['eStatus'] = $dts['eStatus'] = "Active"; $asorgdtls = $orgAssocObj->getDetails('*', " AND iAsociationID={$iAsociationID} "); $where = " AND vAssociationCode='" . $asorgdtls[0]['vAssociationCode'] . "'"; $updt = $orgAssocObj->getDetails('*', $where); $aAssocArr = $_POST['vSupplierOrg'];
$orgAssocVerifyObj = new OrganizationAssociationToVerify(); } $OiAsociationID = $iAsociationID = $_GET['id']; $view = 'verify'; $msg = $smarty->get_template_vars('MSG_NEED_VERIFY'); $orgAssocObj->setiAsociationID($iAsociationID); $asocdt = $orgAssocObj->select(); // prints($asocdt); exit; if ($sess_usertype_short == 'OA' && $asocdt[0]['iBuyerOrganizationID'] != $curORGID) { header("Location: " . SITE_URL_DUM . "associationlist"); exit; } $vAsocode = $asocdt[0]['vAssociationCode']; $fields = " *, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,\r\n\t\t\t\t\t(Select vCompanyName from b2b_organization_master where iOrganizationID=iSupplierAssocationID) as vSupplierOrg "; //$Oassorgdt = $assorgdt = $orgAssocObj->getDetails($fields," AND iAsociationID=$iAsociationID",'','',''); $Oassorgdt = $assorgdt = $orgAssocObj->getDetails($fields, " AND vAssociationCode='{$vAsocode}'", '', '', ''); //print_r($iAsociationID); // prints($assorgdt); exit; for ($l = 0; $l < count($Oassorgdt); $l++) { if ($Oassorgdt[$l]['eStatus'] == 'Need to Verify' || $Oassorgdt[$l]['eStatus'] == 'Modified' || $Oassorgdt[$l]['eStatus'] == 'Delete' || ($Oassorgdt[$l]['eStatus'] == 'Active' || $Oassorgdt[$l]['eStatus'] == 'Inactive') && $Oassorgdt[$l]['eNeedToVerify'] == 'Yes') { $verifyreq = 'Yes'; } /*if($assorgdt[$l]['eStatus'] == 'Modified' || (($assorgdt[$l]['eStatus'] == 'Active' || $assorgdt[$l]['eStatus'] == 'Inactive') && $assorgdt[$l]['eNeedToVerify'] == 'Yes')) { $verifyAssocreq='Yes'; }*/ } //print "a".$verifyreq; // prints($Oassorgdt); $verifyreq = isset($verifyreq) ? $verifyreq : ''; if ($verifyreq == 'Yes') {
$where .= " AND vCompanyName LIKE '%{$orgname}%'"; $ISSEARCHED = 'Yes'; } $where .= " AND eStatus!='Need to Verify' AND eStatus!='Inactive' AND NOT (eStatus='Delete' AND eNeedToVerify='No') "; if (!isset($ENABLE_AUCTION) || $ENABLE_AUCTION == 'No') { $where .= " AND eOrganizationType!='Buyer2'"; } /* if(trim($asocCode) != '') { $whr .= " AND vAssociationCode!='$asocCode'"; } */ //$where .= "AND iUserID!=$iUserID"; // $whr .= ""; $whr = isset($whr) ? $whr : ''; $sellerorgs = $orgAssocObj->getDetails('iSupplierAssocationID', " AND iUserID={$iUserID} {$whr} "); //echo $where;exit; $orderBy = " iOrganizationID Asc"; // echo $where; exit; $res = $orgObj->getDetails('vOrganizationCode,vCompanyName,vCompanyRegNo,iOrganizationID', $where, $orderBy); // prints($res);exit; $cnt = count($res); //echo $cnt;exit; ?> <select name="Data[iOrganizationID]" id="iOrganizationID" class="required" title="<?php echo $smarty->get_template_vars('MSG_SELECT_ORGANIZATION'); ?> " onchange="return fillCompData(this.options[this.selectedIndex].value);" > <option value=''>---<?php echo $smarty->get_template_vars('MSG_SELECT_ORGANIZATION'); ?>
} if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION'] != '') { include SITE_CLASS_GEN . "class.validation.php"; $validation = new Validation(); $msg = $validation->CreateHtmlMsg($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION']); unset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_VALIDATION']); } $assorgdt = array(); $res = array(); $sellerorgs = array(); $newarr = array(); if ($iAsociationID != '') { $view = 'edit'; $orgAssocObj->setiAsociationID($iAsociationID); $fields = " *, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,\r\n (Select vCompanyName from b2b_organization_master where iOrganizationID=iSupplierAssocationID) as vSupplierOrg "; $assorgdt = $orgAssocObj->getDetails($fields, " AND iAsociationID={$iAsociationID}", '', '', ''); if ($sess_usertype_short == 'OA' && $assorgdt[0]['iBuyerOrganizationID'] != $curORGID) { header("Location: " . SITE_URL_DUM . "associationlist"); exit; } // prints($assorgdt);exit; if ($assorgdt[0]['eStatus'] == 'Need to Verify' || $assorgdt[0]['eStatus'] == 'Modified') { header('Location:' . SITE_URL_DUM . 'associationview/' . $iAsociationID); exit; } $orgdata = $orgObj->select($assorgdt[0]['iBuyerOrganizationID']); $orgdata[0]['iBuyerOrganizationID'] = $assorgdt[0]['iBuyerOrganizationID']; $where .= " AND eOrganizationType!='Buyer' AND iOrganizationID!='" . $assorgdt[0]['iBuyerOrganizationID'] . "'"; $sellerorgs = $orgAssocObj->getDetails('iSupplierAssocationID,vSupplierCode', " AND iBuyerOrganizationID='" . $assorgdt[0]['iBuyerOrganizationID'] . "' AND vAssociationCode='" . $assorgdt[0]['vAssociationCode'] . "' AND ((eStatus='Active' || eStatus='Inactive') AND eNeedToVerify!='Yes')"); // exit; foreach ($sellerorgs as $k => $v) {
$res = $assvrfObj->del($where); $arr = $assvrfObj->getDetails('iVerifiedID',$where); foreach($arr as $k=>$v) { $starr[] = $v['iVerifiedID']; } $str = @implode(',',$starr); $where = "AND iItemID IN ($str)"; $res = $userActionObj->del($where); */ $sess_user_name = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_NAME']; $sess_usertype_short = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; if ($mode == 'status') { $where = "AND iAsociationID IN ({$val})"; $arr = $assObj->getDetails('*', $where); foreach ($arr as $k => $v) { $data['eNeedToVerify'] = 'Yes'; $data['iModifiedByID'] = $sess_id; $data['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $data['dModifiedDate'] = date('Y-m-d H:i:s'); $whr = " vAssociationCode='" . $v['vAssociationCode'] . "'"; $asdt = $assObj->getDetails('iChangeNo', " AND " . $whr, ' iChangeNo DESC ', '', ' LIMIT 0,1'); // prints($asdt); exit; if ($asdt[0]['iChangeNo'] == '') { $asdt[0]['iChangeNo'] = 0; } $adtl['iChangeNo'] = $asdt[0]['iChangeNo'] + 1; if ($v['eStatus'] == 'Active') { $assocStr = $assObj->getDetails('group_concat(iAsociationID) as Assoc', ' AND vAssociationCode="' . $v['vAssociationCode'] . '" and eStatus="Active"'); // prints($assocStr);exit;
//$sess_id } if (!isset($asocObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationAssociation.php"; $asocObj = new OrganizationAssociation(); } $vl = $_GET['q']; $orgid = $_GET['orgid']; // $type = $_GET['type']; // $orgtype = $_GET['orgtype']; // $iId = $_GET['iId']; // prints($_GET); exit; $res = array(); if ($orgid != 'undefined' && trim($orgid) != '' && $orgid > 0 && $vl != 'undefined' && trim($vl) != '') { $where = " AND vAssociationCode LIKE '%" . $vl . "%' AND iBuyerOrganizationID={$orgid}"; $res = $asocObj->getDetails(' DISTINCT vAssociationCode as vTitle,vAssociationCode as Id', $where); } /*else if($vl != 'undefined' && trim($vl) != '') { $where = " AND vAssociationCode REGEXP '^".$vl."'"; }*/ // echo $where; exit; /*if($_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT'] == 'OA') { $where .= " AND (iOrganizationID='".$_SESSION['SESS_'.PRJ_CONST_PREFIX.'_ORGID']."')"; }*/ /*if(trim($orgtype) != '') { $where .= " AND (eOrganizationType='$orgtype' OR eOrganizationType='Both')"; }*/ //echo $where;exit; // $res = $asocObj->getDetails('vAssociationCode as vTitle,vAssociationCode as Id',$where); //prints($res);exit; $html = "";
<?php include S_SECTIONS . "/member/memberaccess.php"; if (!isset($orgObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (!isset($orgAssocObj)) { require_once SITE_CLASS_APPLICATION . "organization/class.OrganizationAssociation.php"; $orgAssocObj = new OrganizationAssociation(); } $iAsociationID = $_GET['id']; $view = 'verify'; $msg = $smarty->get_template_vars('MSG_NEED_VERIFY'); $asocdtls = $orgAssocObj->select($iAsociationID); $asocCode = $asocdtls[0]['vAssociationCode']; $fields = " *, (Select vCompanyName from b2b_organization_master where iOrganizationID=iBuyerOrganizationID) as vBuyerOrg,\r\n\t\t\t\t\t(Select vCompanyName from b2b_organization_master where iOrganizationID=iSupplierAssocationID) as vSupplierOrg "; $assorgdt = $orgAssocObj->getDetails($fields, " AND vAssociationCode='{$asocCode}' ", '', '', ''); // prints($assorgdt); exit; $smarty->assign('iAsociationID', $iAsociationID); $smarty->assign('assorgdt', $assorgdt); $smarty->assign('view', $view); $smarty->assign('msg', $msg);