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