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';
$dts['iModifiedByID'] = $sess_id;
// $data['eNeedToVerify']='Yes';
/*if($chkMulAdmin == '1'){
$data['eStatus'] = 'Active';
$data['eNeedToVerify']='No';
}else{
$data['eStatus'] = $data['eStatus'];
}*/
/*$asdt = $orgAssocObj->getDetails('iChangeNo'," AND vAssociationCode='$vAssociationCode' ",' iChangeNo DESC ','',' LIMIT 0,1');
// prints($asdt); exit;
if($asdt[0]['iChangeNo'] == '') {
$asdt[0]['iChangeNo'] = 0;
}
$data['iChangeNo'] = ($asdt[0]['iChangeNo']+1);
// prints($data['iChangeNoId']); exit;*/
$orgAssocVerifyObj->setAllVar($data);
$ascvrfyid = $orgAssocVerifyObj->insert();
unset($data['eNeedToVerify']);
$msg = "rus";
// $where = 'AND iSMID != '.$_SESSION['SESS_'.PRJ_CONST_PREFIX.'_ID'].' AND eStatus = "Active" AND eEmailNotification="Yes" ';
// $smdtls = $secManObj->getDetails('*',$where);
// ---------------------
// -----------
} else {
$msg = "ruserr";
}
} else {
if (!in_array($iSupplierAssocationID[$l], $asoc_ary)) {
//if(count($emlar) > 0) {
$adata['eStatus'] = 'Modified';
/*} else {
$adata = $data;
$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'];
$CODE = $orgdata[0]['vOrganizationCode'];
$where = 'AND iSMID != ' . $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'] . ' AND eStatus = "Active"';
$smdtls = $secManObj->getDetails('*', $where);
// ---------------------
$where = 'AND vType="Association Deleted" AND eSection = "Member"';
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL_DUM . "associationview/" . $v['iAsociationID'];
$body = array("#ORGNAME#", "#ACODE#", "#LINK#", "#DELETE_BY#");
$post = array($ORGNAME, $CODE, $link, $sess_user_name . "({$sess_usertype_short})");
$rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
