$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;
}
} elseif ($v['eStatus'] == 'Inactive') {
$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'] = 'Active';
//$orgGroupObj->setAllVar($data);
$where = "iGroupID = " . $v['iGroupID'] . "";
$adata['iModifiedByID'] = $Data['iModifiedByID'] = $sess_id;
$adata['eModifiedBy'] = $Data['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
$adata['dModifiedDate'] = $Data['dModifiedDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
$orgGroupObj->setAllVar($adata);
$where = " iGroupID = '{$iGroupID}'";
$res = $orgGroupObj->updateData($adata, $where);
## UPDATE INTO VERIFY TABLE
$Data_verify = $Data;
// prints($Data_verify); exit;
$Data_verify['iGroupID'] = $iGroupID;
//if(count($emlar)>0)
$Data_verify['eStatus'] = 'Modified';
/*else
$Data_verify['eStatus'] = 'Active';*/
$orgGroupVerifyfObj->setAllVar($Data_verify);
$vrfres = $orgGroupVerifyfObj->insert();
// $where = 'AND iSMID != '.$_SESSION['SESS_'.PRJ_CONST_PREFIX.'_ID'].' AND eStatus = "Active" AND eEmailNotification="Yes" ';
// $smdtls = $secManObj->getDetails('*',$where);
// ---------------------
if (count($emailarr) > 0) {
$where = 'AND vType="Group Updated" AND eSection = "Member"';
$db_email = $emailObj->getDetails('*', $where);
$link = SITE_URL_DUM . "groupview/" . $iGroupID;
$body = array("#GNAME#", "#ORGNAME#", "#CODE#", "#LINK#", "#MODIFIED_BY#");
$post = array($GNAME, $orgnm, $CODE, $link, $sess_user_name . "({$sess_usertype_short})");
$rplarr = array("Hello #SMNAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
$tbody_en = str_replace($rplarr, " ", $db_email[0]['tBody_en']);
$emailContent_en = trim(str_replace($body, $post, $tbody_en));
$tbody_fr = str_replace($rplarr, " ", $db_email[0]['tBody_fr']);
$emailContent_fr = trim(str_replace($body, $post, $tbody_fr));
// prints($emailContent);exit;
