// 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';
