$OgrpData = $grpData = $orgGroupObj->select($iGroupID); if ($sess_usertype_short == 'OA' && $grpData[0]['iOrganizationID'] != $curORGID) { header("Location: " . SITE_URL_DUM . "grouplist"); exit; } // $msg = $smarty->get_template_vars('MSG_NEED_VERIFY'); // prints($grpData);exit; $OuserStatus = $userStatus = @explode(";", $grpData[0]['tPermission']); $Oorgdata = $orgdata = $orgObj->select($grpData[0]['iOrganizationID']); $where = ' AND iUserID IN (' . $grpData[0]['tUserID'] . ')'; $Ouserdata = $userdata = $UsrObj->getDetails("CONCAT(vFirstName,' ',vLastName) as vTitle,iUserID as Id", $where); $where = " "; $Ostatus = $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', $where, 'iDisplayOrder', ''); //prints($status);exit; $where = 'AND iGroupID = ' . $iGroupID . ''; $gdts = $orgGroupVerifyfObj->getDetails('*', $where, ' iVerifiedID desc ', '', ' LIMIT 0,1 '); if ($gdts[0]['eStatus'] == 'Modified' || $gdts[0]['eNeedToVerify'] == 'Yes' || $gdts[0]['eStatus'] == 'Inactive') { $where = 'AND iGroupID = ' . $iGroupID . ''; $orderby = ' iVerifiedID Desc'; $grpData = $orgGroupVerifyfObj->getDetails('*', $where, $orderby); $orgdata = $orgObj->select($grpData[0]['iOrganizationID']); $where = ' AND iUserID IN (' . $grpData[0]['tUserID'] . ')'; $userdata = $UsrObj->getDetails("CONCAT(vFirstName,' ',vLastName) as vTitle,iUserID as Id", $where); //prints($userdata);exit; $where = " "; $status = $orgStaObj->getDetails('vStatus_' . LANG . ' as title,vStatusMsg_' . LANG . ',iStatusID as Id,eFor,eType,vStatus_en as status', $where, 'iDisplayOrder', ''); $userStatus = @explode(";", $grpData[0]['tPermission']); } $invUserStatus = $userStatus[0]; $invUserStatus = str_replace("inv:", "", $invUserStatus); $poUserStatus = $userStatus[1];
} $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 iGroupID IN ({$val})"; $arr = $orgGroupObj->getDetails('*', $where); foreach ($arr as $k => $v) { $GNAME = $v['vGroupName']; $data = $v; $data['eNeedToVerify'] = 'Yes'; $data['iModifiedByID'] = $sess_id; $data['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $data['dModifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s'); if ($v['eStatus'] == 'Active') { $whr = " AND iGroupID=" . $v['iGroupID']; $varr = $ogrpvrfObj->getDetails('*', $whr, ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); if (($varr[0]['eStatus'] == 'Active' || $varr[0]['eStatus'] == 'Inactive') && $varr[0]['eNeedToVerify'] != 'Yes') { $data['eStatus'] = 'Inactive'; //$orgGroupObj->setAllVar($data); $where = "iGroupID = " . $v['iGroupID'] . ""; //$res = $orgGroupObj->updateData($data, $where); $ogrpvrfObj->setAllVar($data); $res = $ogrpvrfObj->insert(); //$res = $ogrpvrfObj->updateData($data, $where); // $orgGroupObj->updateData(array('eStatus'=>'Modified'),$where) // $orgGroupObj->updateData(array('eNeedToVerify'=>'Yes','eStatus'=>'Inactive'),$where);; } else { $var_msg = $smarty->get_template_vars('MSG_VERIFY_NEED_TO_VERIFY_OR_MODIFIED'); echo $var_msg; exit; }
} if($_POST['Order']) { $Order = @implode(',',$_POST['Order']); $po = $po.','.$Order; } */ $newarr = $inv . $po; $Data['tPermission'] = $newarr; $newary = $inva . $poa; $Data['tAcceptancePermit'] = $newary; $Data['eInvFPO'] = isset($_POST['eInvFPO']) ? $_POST['eInvFPO'] : 'No'; if ($view == 'reject') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = 'No'; $dt['eStatus'] = $dts['eStatus'] = "Inactive"; $usrgrpdtls = $orgGroupObj->getDetails('*', " AND iGroupID={$iGroupID} "); $grpvrfydt = $orgGroupVerifyfObj->getDetails('*', " AND iGroupID={$iGroupID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 '); if ($usrgrpdtls[0]['eStatus'] == 'Need to Verify') { $dt['eStatus'] = $dts['eStatus'] = "Inactive"; } else { if ($grpvrfydt[0]['eStatus'] == 'Inactive' && $grpvrfydt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No"; $dt['eStatus'] = $dts['eStatus'] = "Active"; } else { if ($grpvrfydt[0]['eStatus'] == 'Active' && $grpvrfydt[0]['eNeedToVerify'] == 'Yes') { $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No"; $dt['eStatus'] = $dts['eStatus'] = "Inactive"; } else { if ($usrgrpdtls[0]['eStatus'] == 'Modified') { $dt['eStatus'] = $dts['eStatus'] = "Active"; $dts['iModifiedByID'] = ""; $dts['eModifiedBy'] = "";