コード例 #1
0
 $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;
 								 $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();
 
コード例 #2
0
                             if ($updt[$ln]['eStatus'] == 'Delete') {
                                 $dt['eStatus'] = $dts['eStatus'] = "Active";
                                 $dts['iModifiedByID'] = "";
                                 $dts['eModifiedBy'] = "";
                             }
                         }
                     }
                 }
             }
             if ($dt['eStatus'] == 'Delete') {
                 $where = " AND iAsociationID='" . $updt[$ln]['iAsociationID'] . "'";
                 $res = $orgAssocObj->del($where);
                 $dt['eStatus'] = $dts['eStatus'] = "Inctive";
                 $dt['eNeedToVerify'] = $dts['eNeedToVerify'] = "No";
             } else {
                 $res = $orgAssocObj->updateData($dts, " iAsociationID=" . $updt[$ln]['iAsociationID']);
             }
             $dt['iRejectedById'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
             $dt['eRejectedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
             $dt['tReasonToReject'] = $reasonToReject[$updt[$ln]['iAsociationID']];
             $dt['dRejectedDate'] = date("Y-m-d H:i:s");
             //	$vrfydtls = $orgAssocVerifyObj->getDetails('*'," AND iAsociationID=$iAsociationID "," AND dCreatedDate DESC",''," LIMIT 0,1");
             $rs = $orgAssocVerifyObj->updateData($dt, " iAsociationID=" . $updt[$ln]['iAsociationID']);
         }
     }
 }
 if ($res) {
     $msg = "rus";
 } else {
     $msg = "ruserr";
 }
コード例 #3
0
ファイル: delasso.php プロジェクト: nstungxd/F2CA5
    $sendMail = new SendPHPMail();
}
$where = " AND iAsociationID IN ({$val}) ";
$arr = $orgAssocObj->getDetails('*', $where);
foreach ($arr as $k => $v) {
    if ($v['eNeedToVerify'] != 'Yes') {
        $dlts['eStatus'] = 'Delete';
        // $dlts['eNeedToVerify'] = 'Yes';
        $dlts['iModifiedByID'] = $sess_id;
        $dlts['eModifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
        $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'];