Пример #1
0
 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;
Пример #2
0
         // $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;
Пример #3
0
 $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#");