/* if($ISSEARCHED != 'Yes'){ $where .= " AND iOrganizationID IN ($iSellerOrgs) "; }else{ */ //$where .= " AND iOrganizationID NOT IN ($iSellerOrgs) "; /*if($islorgs != '') $where .= " AND iOrganizationID NOT IN ($iSellerOrgs".','."$islorgs) "; else $where .= " AND iOrganizationID NOT IN ($iSellerOrgs) "; */ // } } // echo $where;exit; $orderBy = " iOrganizationID Asc"; //echo $where; exit; $res = $orgObj->getDetails('vOrganizationCode,vCompanyName,vCompanyRegNo,iOrganizationID', $where, $orderBy); // print_r($res);exit; if (count($res) > 0 && is_array($res)) { ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td class="blue-hadd-bg"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="30px" height="26" > <input type="checkbox" class="radib-btn" name="uid_chkall" id="uid_chkall" style="vertical-align:middle;" /> </td> <td width="70px" >Reg. No. </td> <td width="100px" >Organization Code</td> <td width="100px" >Organization Name</td> <td width="70px" align="center">Code </td>
if (!isset($sproductObj)) { include_once SITE_CLASS_APPLICATION . 'productorganization/class.SProductOrganization.php'; $sproductObj = new SProductOrganization(); } $product_dtls = $sproductObj->select($rfq2pb2_dtls[0]['iProductId']); } } } $buyer2ids = multi21Array($rfq2pb2_dtls, 'iBuyer2Id'); $buyer2ids = array_unique($buyer2ids); $buyer2ids = array_filter($buyer2ids); $b2ids = ''; if (is_array($buyer2ids) && count($buyer2ids) > 0) { $b2ids = @implode(',', $buyer2ids); } $buyer2_dtls = $orgObj->getDetails('*', " AND iOrganizationID IN ({$b2ids}) "); // pr($buyer2_dtls); exit; } // pr($product_dtls); exit; // pr($dtls); exit; $vreq = 'n'; $permitted = 'n'; $orgprf = $orgprefObj->getDetails('*', " AND iOrganizationID=" . $dtls[0]['iOrganizationID']); if (($dtls[0]['vStatus_en'] == 'Create' && $orgprf[0]['eRFQ2VerifyReq'] == 'Yes' || $dtls[0]['eDelete'] == 'Yes') && $sess_usertype_short == 'OU') { $vreq = 'y'; if ($dtls[0]['iModifiedById'] != $sess_id && $dtls[0]['iOrganizationID'] == $curORGID) { $rfq2vp = $orgUserPermObj->getUserRfq2Permits($sess_id); if (isset($rfq2vp['Verify']) && $rfq2vp['Verify'] == 'y') { $permitted = 'y'; } }
} // prints($uarr); exit; if (is_array($sar) && is_array($uar)) { $emlar = array_merge($sar, $uar); } else { if (is_array($sar)) { $emlar = $sar; } else { if (is_array($uar)) { $emlar = $uar; } } } // prints($Data);exit; $where = 'AND iOrganizationID = ' . $iOrganizationID . ''; $ordata = $orgObj->getDetails('*', $where); $sname = $arr[0]['vFirstName'] . ' ' . $arr[0]['vLastName']; $cname = $ordata[0]['vCompanyName']; $regno = $ordata[0]['vCompanyRegNo']; $code = $ordata[0]['vOrganizationCode']; if ($view == 'reject') { //echo $view; exit; $iOrganizationID = $_POST['iOrgId']; $dt['eNeedToVerify'] = $data['eNeedToVerify'] = 'No'; $dt['tReasonToReject'] = $_POST['tReasonToReject']; $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dt['dRejectedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $dt['eStatus'] = $data['eStatus'] = "Active"; $orgpfdtls = $orgprefObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} "); if ($orgpfdtls[0]['eStatus'] == 'Need to Verify') {
$where .= " AND (eOrganizationType='{$orgtype}' OR eOrganizationType='Both')"; } if (trim($assoc) != '' && trim($assoc) != 'all') { $where .= " AND iOrganizationID IN (Select iSupplierAssocationID from " . PRJ_DB_PREFIX . "_organization_association where vAssociationCode='{$assoc}' AND eStatus='Active' AND eNeedToVerify='No') "; } $where .= " AND eStatus='Active' AND eNeedToVerify!='Yes' " . $orgWhere; // echo $where;exit; //print $where; if ($extc = 'invb') { $where .= " AND iOrganizationID IN (Select iBuyerOrganizationID from " . PRJ_DB_PREFIX . "_organization_association where iSupplierAssocationID='" . $_GET['orgid'] . "') "; } else { if ($extc = 'invs') { $where .= " AND iOrganizationID IN (Select iSupplierAssocationID from " . PRJ_DB_PREFIX . "_organization_association where iBuyerOrganizationID='" . $_GET['orgid'] . "') "; } } $res = $orgObj->getDetails('vOrganizationCode,vCompanyName as vTitle,vCompanyRegNo,iOrganizationID as Id', $where, "vCompanyName"); // prints($res);exit; $html = ""; if ($orgtype == 'supplier') { $compName = $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_SUPPLIER') . " " . $smarty->get_template_vars('LBL_COMPANY'); } elseif ($orgtype == 'buyer' && $isAssociation == '') { $compName = $smarty->get_template_vars('LBL_SELECT') . " " . $smarty->get_template_vars('LBL_BUYER') . " " . $smarty->get_template_vars('LBL_COMPANY'); } elseif ($orgtype == 'buyer' && $isAssociation == 'yes') { $compName = $smarty->get_template_vars('MSG_SELECT_BUYER_ORGANIZATION'); } elseif ($orgtype == '' && $isAssociation == 'no') { $compName = $smarty->get_template_vars('MSG_SELECT_ORGANIZATION'); } if (count($res) > 0 && is_array($res)) { $i = 0; if ($htmlTag == "option") { $html = "<option value=''>---" . $compName . "---</option>";
$OuserData = $userData = $userData[0]; $uprmts = $orgUserPerObj->getDetails('*', " AND iUserID={$iUserID} "); $vuprmts = $orgUserPermVerifyObj->getDetails('*', " AND iUserID={$iUserID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); } $state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode"); $stateArr = $state[0]; //$stateArr = array($stateArr); //echo $stateArr[0][2]; //prints($stateArr);exit; $groupArr = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_organization_group", " AND eStatus='Active' ", "iGroupID", "vGroupName", "iOrganizationID", "iGroupID,vGroupName,iOrganizationID"); $groupArr = $groupArr[0]; $db_country = $countryObj->getCountryDetail("iCountryId,vCountry,vCountryCode", "AND eStatus = 'Active'"); //prints($db_country);exit; $db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $userData['vCountry'] . "'", "vState"); $where = " AND iOrganizationID=" . $OuserData['iOrganizationID'] . ""; $organization = $orgObj->getDetails('*', $where); // prints($organization); exit; $msg = $smarty->get_template_vars('MSG_NEED_VERIFY'); //prints($userData);exit; if ($userData['eUserType'] != '') { $userTypeVal = $userData['eUserType']; } else { $userTypeVal = 'User'; } $userTypes = $gdbobj->getEnumSelect("" . PRJ_DB_PREFIX . "_organization_user", "eUserType", "Data[eUserType]", "eUserType", "", $userTypeVal, "style='width:200px;' class='drop-down' ", "Select User Type"); //$eStatus = $gdbobj->getEnumSelect("".PRJ_DB_PREFIX."_organization_user", "eStatus","Data[eStatus]", "eStatus","",$statusVal,"style='width:200px;' class='drop-down' ","Select Status"); $where = 'AND iUserID = ' . $iUserID . ''; $udts = $userToVerifyObj->getDetails('*', $where, ' iVerifiedID desc ', '', ' LIMIT 0,1 '); $udts = $udts[0]; //prints($udts);//exit; if ($udts['eStatus'] == 'Modified' || $udts['eNeedToVerify'] == 'Yes' || $udts['eStatus'] == 'Delete') {
if (strpos($ures[0]['eImportCreation'], 'po') !== false) { $eimport['po'] = 'Yes'; } if (strpos($ures[0]['eImportCreation'], 'inv') !== false) { $eimport['inv'] = 'Yes'; } $ures[0]['eVerify'] = isset($ures[0]['eVerify']) ? $ures[0]['eVerify'] : ''; if (strpos($ures[0]['eVerify'], 'pi:ia') !== false) { $everify['po'] = 'Yes'; } if (strpos($ures[0]['eVerify'], 'ii:pa') !== false) { $everify['inv'] = 'Yes'; } // prints($poUserAcpt); exit; $where = " AND iOrganizationID='" . $userdata[0]['iOrganizationID'] . "'"; $orgdata = $orgObj->getDetails('vCompanyName,eOrganizationType', $where); $orgname = $orgdata[0]['vCompanyName']; $where = ""; $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', $where, 'iDisplayOrder', ''); // prints($ures); exit; $ures[0]['eStatus'] = isset($ures[0]['eStatus']) ? $ures[0]['eStatus'] : ''; if ($ures[0]['eStatus'] == 'Need to Verify') { switch ($sess_usertype) { case 'securitymanager': if ($ures[0]['eCreatedBy'] == 'SM') { if ($ures[0]['iCreatedBy'] != $sess_id) { $verify = 'yes'; } else { $verify = 'no'; } } else {
} } else { $mod = 'add'; $arr = $post_data = array(); if (isset($_SESSION[PRJ_CONST_PREFIX . '_postdata'])) { $post_data = unserialize($_SESSION[PRJ_CONST_PREFIX . '_postdata']); unset($_SESSION[PRJ_CONST_PREFIX . '_postdata']); } if (isset($post_data['Data']) && count($post_data['Data']) > 0) { $arr[0] = $post_data['Data']; if (isset($arr[0]['iBuyer2Id']) && $arr[0]['iBuyer2Id'] > 0) { if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } $buyer2 = $orgObj->getDetails('vCompanyName,vCompCode', " AND iOrganizationID='" . $arr[0]['iBuyer2Id'] . "'"); $arr[0]['vBuyer2'] = $buyer2[0]['vCompanyName']; $arr[0]['vB2Code'] = $buyer2[0]['vCompCode']; } $arr[0]['iProductId'] = 0; } // pr($arr); exit; } // For OAs if (isset($_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE']) && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ORGTYPE'] != 'Buyer2' && $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USRTYPE'] != 'SM') { if ($iAssociationId > 0) { header("Location: " . SITE_URL_DUM . "b2bprodtasocview/{$iAssociationId}"); } else { header("Location: " . SITE_URL_DUM . "b2bprodtasoclist"); } exit;
if (!isset($orgObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.Organization.php"; $orgObj = new Organization(); } if (trim($snm) != '' && trim($scd) == '') { $whr .= " AND vCompanyName LIKE '%{$snm}%' "; } else { if (trim($scd) != '' && trim($snm) == '') { $whr .= " AND vCompCode LIKE '%{$scd}%' "; } else { if (trim($scd) != '' && trim($snm) != '') { $whr .= " AND (vCompanyName LIKE '%{$snm}%' OR vCompCode LIKE '%{$scd}%') "; } } } $b2orgs = $orgObj->getDetails("*", " AND eOrganizationType='Buyer2' AND eStatus='Active' {$whr} ", " vCompanyName ASC "); // prints($b2orgs); exit; if (is_array($b2orgs) && count($b2orgs) > 0) { $ln = count($b2orgs); $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' onchange='return {$oc};' style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "'>"; for ($l = 0; $l < $ln; $l++) { $html .= "<option value='" . $b2orgs[$l]['iOrganizationID'] . "'>" . $b2orgs[$l]['vCompanyName'] . " (" . $b2orgs[$l]['vCompCode'] . ")" . "</option>"; } $html .= "</select>"; } else { $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' onchange='return {$oc};' style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "'>"; $html .= "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER2') . "---</option>"; $html .= "</select>"; } echo $html; exit;
$whr .= " AND vCompCode LIKE '%{$scd}%' "; } else { if (trim($scd) != '' && trim($snm) != '') { $whr .= " AND (vCompanyName LIKE '%{$snm}%' OR vCompCode LIKE '%{$scd}%') "; } } } if (trim($iBuyer2Id) != '' && $iBuyer2Id > 0 && trim($iProductId) != '' && $iProductId > 0) { $whr .= " AND iOrganizationID NOT IN (Select iBuyerId from " . PRJ_DB_PREFIX . "_buyer2_buyer_bproduct_association where iBuyer2Id={$iBuyer2Id} AND iProductId={$iProductId} AND NOT (eStatus='Delete' AND eNeedToVerify='No'))"; } if (trim($sid) != '' && $sid > 0) { $whr .= " OR iOrganizationID={$sid} "; } $whr .= " AND (eOrganizationType='Buyer' OR eOrganizationType='Both') AND iOrganizationID IN (Select iBuyerId from " . PRJ_DB_PREFIX . "_buyer2_buyer_association where iBuyer2Id={$iBuyer2Id} AND NOT (eStatus='Delete' AND eNeedToVerify='No') AND eStatus!='Need to Verify') "; // echo $whr; exit; $borg = $orgObj->getDetails("*", " AND eStatus='Active' AND eNeedToVerify!='Yes' {$whr} ", " vCompanyName ASC "); // prints($borg); exit; if (is_array($borg) && count($borg) > 0) { $ln = count($borg); $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "'>"; for ($l = 0; $l < $ln; $l++) { $sel = ""; if ($sid > 0 && $borg[$l]['iOrganizationID'] == $sid) { $sel = "selected='selected'"; } $html .= "<option value='" . $borg[$l]['iOrganizationID'] . "' {$sel} >" . $borg[$l]['vCompanyName'] . " (" . $borg[$l]['vCompCode'] . ")" . "</option>"; } $html .= "</select>"; } else { $html .= "<select id='{$fid}' name='{$fnm}' class='{$cls}' {$ea} style='{$styl}' title='" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "'>"; $html .= "<option value=''>---" . $smarty->get_template_vars('LBL_SELECT') . ' ' . $smarty->get_template_vars('LBL_BUYER') . "---</option>";
if (!isset($countryObj)) { include_once SITE_CLASS_APPLICATION . "class.Country.php"; $countryObj = new Country(); } if (!isset($stateObj)) { include_once SITE_CLASS_APPLICATION . "class.State.php"; $stateObj = new State(); } if (!isset($cntstObj)) { include_once SITE_CLASS_GEN . "class.countrystate.php"; $cntstObj = new CountryState(); } if ($iOrganizationID != '') { $view = 'edit'; $where = 'AND iOrganizationID = ' . $iOrganizationID . ''; $Oarr = $arr = $orgObj->getDetails('*', $where); $Oprefarr = $prefarr = $orgprefObj->getDetails('iAdditionalInfoID', $where); $OiAdditionalInfoID = $iAdditionalInfoID = $prefarr[0]['iAdditionalInfoID']; // prints($arr);exit; } //Get State Array $state = $cntstObj->getgeneralArr(PRJ_DB_PREFIX . "_state_master", " AND eStatus='Active'", "vStateCode", "vState", "vCountryCode", "vStateCode,vState,vCountryCode"); $stateArr = $state[0]; //prints($stateArr);exit; $db_country = $countryObj->getCountryDetail("iCountryId,vCountry,vCountryCode", "AND eStatus = 'Active'"); //prints($db_country);exit; $db_state = $stateObj->getStateDetail("iStateId, vStateCode, vState", "AND eStatus = 'Active' AND vCountryCode = '" . $arr[0]['vCountry'] . "'", "vState"); //prints($db_state);exit; // pr($arr); exit; $verify = ''; $smarty->assign('stateArr', $stateArr);
$emailObj = new EmailTemplate(); } if (!isset($sendMail)) { include_once SITE_CLASS_GEN . "class.sendmail.php"; $sendMail = new SendPHPMail(); } if (!isset($statusmasterObj)) { include_once SITE_CLASS_APPLICATION . "class.StatusMaster.php"; $statusmasterObj = new StatusMaster(); } $Data = $_POST['Data']; $iUserId = $Data['iUserID']; $iPermissionID = isset($_POST['iPermissionID']) ? $_POST['iPermissionID'] : ''; $view = $_POST['view']; $usrdt = $orgUsrObj->getDetails('*', " AND iUserID={$iUserId}"); $orgdt = $orgObj->getDetails('*', " AND iOrganizationID=" . $usrdt[0]['iOrganizationID'] . ""); // prints($orgdt);exit; // pr($_POST); exit; if ($iUserId != '') { $uprmt = $orgUserPermObj->getDetails('*', " AND iUserID={$iUserId}"); if (is_array($uprmt) && count($uprmt) > 0) { if (($uprmt[0]['eStatus'] == 'Active' || $uprmt[0]['eStatus'] == 'Inactive') && $uprmt[0]['eNeedToVerify'] != 'Yes') { // prints($orgdt); exit; } else { if (($view == 'edit' || $view == 'add' || $view == '') && count($uprmt) > 0 && $_SESSION['from'] != 'usr') { header('Location:' . SITE_URL_DUM . 'organizationuserlist'); exit; } } } }
$orgprefObj = new OrganizationPreference(); } if (!isset($orgPrefVrfObj)) { include_once SITE_CLASS_APPLICATION . "organization/class.OrganizationPreferenceToverify.php"; $orgPrefVrfObj = new OrganizationPreferenceToverify(); } $activationcode = GetVar('msg'); if (trim($activationcode) == '') { header("Location: " . SITE_URL_DUM . "home"); exit; } //$id = $orgObj->getid($activationcode); $where = " vActivationCode='{$activationcode}' "; $data['eStatus'] = 'Active'; $data['vActivationCode'] = ''; $dtls = $orgObj->getDetails('*', ' AND ' . $where); if (is_array($dtls) && count($dtls) > 0 && isset($dtls[0]['iOrganizationID']) && $dtls[0]['iOrganizationID'] > 0) { $rs = $orgObj->updateData($data, $where); $r = $orgUsrObj->updateData($data, $where); // unset($data['vActivationCode']); $s = $orgvrfObj->updateData($data, $where); $s = $userToVerifyObj->updateData($data, $where); unset($data['vActivationCode']); $where = " iOrganizationID = " . $dtls[0]['iOrganizationID'] . ""; $s = $orgprefObj->updateData($data, $where); $opdtls = $orgprefObj->getDetails('*', ' AND ' . $where); if (isset($opdtls[0]['iAdditionalInfoID']) && $opdtls[0]['iAdditionalInfoID'] > 0) { $where = " iAdditionalInfoID = " . $opdtls[0]['iAdditionalInfoID'] . ""; $s = $orgPrefVrfObj->updateData($data, $where); } } else {
} $sname = $arr[0]['vFirstName'] . ' ' . $arr[0]['vLastName']; $cname = $Data['vCompanyName']; $regno = $Data['vCompanyRegNo']; $code = isset($Data['vOrganizationCode']) ? $Data['vOrganizationCode'] : ''; // echo $view; exit; if ($view == 'reject') { //echo $view; exit; $iOrganizationID = $_POST['iOrgId']; $dt['eNeedToVerify'] = $data['eNeedToVerify'] = 'No'; $dt['tReasonToReject'] = $_POST['tReasonToReject']; $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dt['dRejectedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); $dt['eStatus'] = $data['eStatus'] = "Active"; $orgdtls = $orgObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} "); $orgvrfdt = $orgvrfObj->getDetails('*', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); if ($orgdtls[0]['eStatus'] == 'Need to Verify') { $dt['eStatus'] = $data['eStatus'] = "Inactive"; } else { if ($orgvrfdt[0]['eStatus'] == 'Inactive' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No"; $dt['eStatus'] = $data['eStatus'] = "Active"; } else { if ($orgvrfdt[0]['eStatus'] == 'Active' && $orgvrfdt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $data['eNeedToVerify'] = "No"; $dt['eStatus'] = $data['eStatus'] = "Inactive"; } else { if ($orgdtls[0]['eStatus'] == 'Modified') { $dt['eStatus'] = $data['eStatus'] = "Active"; $data['iModifiedByID'] = "";
} $view = isset($view) ? $view : ''; if ($iUserID != '') { $view = 'edit'; $where = " AND iUserID='" . $iUserID . "'"; $userdata = $orgUserObj->getDetails('*', $where); $ures = $orgUserPerObj->getDetails('*', $where); $userStatus = @explode(";", $ures[0]['tPermission']); $invUserStatus = $userStatus[0]; $invUserStatus = str_replace("inv:", "", $invUserStatus); $poUserStatus = isset($userStatus[1]) ? $userStatus[1] : ''; $poUserStatus = str_replace("po:", "", $poUserStatus); $invUserStatus = @explode(',', $invUserStatus); $poUserStatus = @explode(',', $poUserStatus); $where = " AND iOrganizationID='" . $userdata[0]['iOrganizationID'] . "'"; $orgdata = $orgObj->getDetails('*', $where); // prints($orgdata); exit; $orgname = $orgdata[0]['vCompanyName']; $where = ""; $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor', $where, 'iDisplayOrder', ''); } $ures[0]['eStatus'] = isset($ures[0]['eStatus']) ? $ures[0]['eStatus'] : ''; if ($ures[0]['eStatus'] == 'Need to Verify') { switch ($sess_usertype) { case 'securitymanager': if ($ures[0]['eCreatedBy'] == 'SM') { if ($ures[0]['iCreatedBy'] != $sess_id) { $verify = 'yes'; } } else { $verify = 'no';