$dts = $v; // $asocs[$l]; $dts['eStatus'] = 'Inactive'; $dts['eNeedToVerify'] = 'Yes'; $dts['iModifiedByID'] = $sess_id; $dts['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dts['dModifiedDate'] = date('Y-m-d H:i:s'); $dts['iChangeNo'] = $adtl['iChangeNo']; $assvrfObj->setAllVar($dts); $res = $assvrfObj->insert(); // $dtl['eNeedToVerify'] = 'Yes'; // $wh = "iAsociationID=".$asocs[$l]['iAsociationID']; // $res = $assObj->updateData($dtl, $wh); // $res = $assObj->updateData($data, $where); // $data['iChangeNo'] = $adtl['iChangeNo']; $res = $assObj->updateData($data, " iAsociationID=" . $v['iAsociationID']); //$assObj->setAllVar($data); /* $where = "iAsociationID in (".$assocStr.")"; $asocs = $assObj->getDetails('*',' AND '.$whr); for($l=0; $l<count($asocs);$l++) { $dts = $asocs[$l]; $dts['eStatus'] = 'Inactive'; $dts['eNeedToVerify']='Yes'; $dts['iModifiedByID'] = $sess_id; $dts['eModifiedBy'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT']; $dts['dModifiedDate'] = date('Y-m-d H:i:s'); $dts['iChangeNo'] = $adtl['iChangeNo']; $assvrfObj->setAllVar($dts); $res = $assvrfObj->insert();
if ($updt[$ln]['eStatus'] == 'Delete') { $dt['eStatus'] = $dts['eStatus'] = "Active"; $dts['iModifiedByID'] = ""; $dts['eModifiedBy'] = ""; } } } } } if ($dt['eStatus'] == 'Delete') { $where = " AND iAsociationID='" . $updt[$ln]['iAsociationID'] . "'"; $res = $orgAssocObj->del($where); $dt['eStatus'] = $dts['eStatus'] = "Inctive"; $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No"; } else { $res = $orgAssocObj->updateData($dts, " iAsociationID=" . $updt[$ln]['iAsociationID']); } $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID']; $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dt['tReasonToReject'] = $reasonToReject[$updt[$ln]['iAsociationID']]; $dt['dRejectedDate'] = date("Y-m-d H:i:s"); // $vrfydtls = $orgAssocVerifyObj->getDetails('*'," AND iAsociationID=$iAsociationID "," AND dCreatedDate DESC",''," LIMIT 0,1"); $rs = $orgAssocVerifyObj->updateData($dt, " iAsociationID=" . $updt[$ln]['iAsociationID']); } } } if ($res) { $msg = "rus"; } else { $msg = "ruserr"; }
$sendMail = new SendPHPMail(); } $where = " AND iAsociationID IN ({$val}) "; $arr = $orgAssocObj->getDetails('*', $where); foreach ($arr as $k => $v) { if ($v['eNeedToVerify'] != 'Yes') { $dlts['eStatus'] = 'Delete'; // $dlts['eNeedToVerify'] = 'Yes'; $dlts['iModifiedByID'] = $sess_id; $dlts['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dlts['dModifiedDate'] = date('Y-m-d H:i:s'); $assObj->setAllVar($dlts); // $where = " iAsociationID IN (".$v['iAsociationID'].") "; $where = " iAsociationID=" . $v['iAsociationID']; // prints($where); exit; $res = $assObj->updateData($dlts, $where); //$assvrfObj->setAllVar($dlts); //$res = $assvrfObj->updateData($dlts, $where); $where = ' AND iAsociationID = ' . $v['iAsociationID'] . ''; $dts = $v; $dts['iModifiedByID'] = $sess_id; $dts['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $dts['dModifiedDate'] = date('Y-m-d H:i:s'); $dts['eStatus'] = 'Delete'; $assvrfObj->setAllVar($dts); $rs = $assvrfObj->insert(); $orderby = ' iVerifiedID Desc'; $vrfid = $assvrfObj->getDetails('iVerifiedID', $where, $orderby); // --------------------- ORGANIZATION DATA FETCHED ------------------------------------------// $orgdata = $orgObj->select($v['iBuyerOrganizationID']); $ORGNAME = $orgdata[0]['vCompanyName'];