// echo $updt[$ln]['iAsociationID']; exit; $where = " AND iAsociationID='" . $aAssocArr[$ln] . "'"; $orderby = 'iVerifiedID Desc'; $vrfdata = $orgAssocVerifyObj->getDetails('*', $where, $orderby, '', ' LIMIT 0,1 '); // prints($vrfdata); exit; // prints($updt); exit; if ($updt[$ln]['eStatus'] == 'Delete') { $iAsociationID = $updt[$ln]['iAsociationID']; $where = " AND iAsociationID='" . $iAsociationID . "'"; $res = $orgAssocObj->del($where); unset($data); $data['eStatus'] = 'Active'; $data['iVerifiedSMID'] = $sess_id; $data['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT']; $data['dVerifiedDate'] = date('Y-m-d H:i:s'); $orgAssocVerifyObj->setAllVar($data); $where = "iAsociationID IN (" . $iAsociationID . ")"; $res = $orgAssocVerifyObj->updateData($data, $where); if ($res) { $msg = "rds"; } else { $msg = "rdserr"; } } else { if (($updt[$ln]['eStatus'] == 'Inactive' || $updt[$ln]['eStatus'] == 'Active') && $updt[$ln]['eNeedToVerify'] == 'Yes' && in_array($updt[$ln]['iAsociationID'], $aAssocArr)) { $where = ""; unset($data); if ($updt[$ln]['eStatus'] == 'Inactive') { $data['eStatus'] = 'Inactive'; } else { $data['eStatus'] = 'Active';
$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; $assocStr = $assocStr[0]['Assoc']; $data['eStatus'] = 'Inactive'; $data['eNeedToVerify'] = 'Yes'; $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';