$iVerifiedID = $dt[0]['iVerifiedID'];
 unset($dt[0]['iVerifiedID']);
 if (count($dt) == 0) {
     $dt['eStatus'] = "Active";
 }
 $res = $orgprefObj->updateData($dt, "iOrganizationID={$iOrganizationID}");
 $rs = $orgObj->updateData($dt, " iOrganizationID={$iOrganizationID} ");
 $verified = $orgvrfObj->getDetails('iVerifiedID', " AND iOrganizationID={$iOrganizationID} ", ' iVerifiedID DESC ', '', ' LIMIT 0,1 ');
 $ivid = $verified[0]['iVerifiedID'];
 $rs = $orgvrfObj->updateData($dt, " iVerifiedID={$ivid} ");
 $where = " iVerifiedID={$iVerifiedID} ";
 $dtls['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
 $dtls['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 $dtls['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
 $dtls['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
 $rs = $userActionObj->updateData($dtls, $where);
 if ($res) {
     $orgdtls = $orgObj->select($iOrganizationID);
     /*if($orgdtls[0]['eOrganizationType'] == 'Supplier'){
     		$opdt['vOrderStatusLevel'] = '';
     		$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
       } else if($orgdtls[0]['eOrganizationType'] == 'Buyer'){
     		$opdt['vInvoiceStatusLevel'] = '';
     		$rs = $orgprefObj->updateData($opdt,"iOrganizationID=$iOrganizationID");
       }*/
     $rs = $orgUserPermObj->clearExtraPermits($iOrganizationID, $orgdtls[0]['eOrganizationType']);
     // $rs = $orgUserPermObj->clearExPermits($iOrganizationID,$orgdtls[0]['eOrganizationType'],$Data1);
 }
 //   $orgObj->setAllVar($Data);
 //	$res = $orgvrfObj->insert();
 // CHANGE STATUS IN ORGANIZATION MASTER
Beispiel #2
0
 $nsts = $dt['iStatusID'];
 if (isset($_POST['Data']['fAcceptedAmount']) && $dt['iaStatusID'] > 0) {
     $dt['fAcceptedAmount'] = $_POST['Data']['fAcceptedAmount'];
     $dt['dAcceptedVat'] = $_POST['Data']['dAcceptedVat'];
     $dt['dAcceptedOtherTax'] = $_POST['Data']['dAcceptedOtherTax'];
     $dt['dAcceptedWHTax'] = $_POST['Data']['dAcceptedWHTax'];
     $dt['dAcceptedNetPaymentDate'] = $_POST['Data']['dAcceptedNetPaymentDate'];
 }
 // pr($_POST);
 // pr($dt); exit;
 $id = $invOrdObj->updateData($dt, " iInvoiceID={$iInvoiceID} ");
 $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
 $vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
 $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
 $res = $userActionObj->updateData($vrfydt, "iItemID={$iInvoiceID} AND eSubject='Invoice'");
 // prints($act); exit;
 if ($id) {
     $act = $act[0]['vStatus_en'];
     if ($dt['iaStatusID'] == $cstsdtl[0]['iStatusID']) {
         $sub1 = "New Invoice Created";
         $type = "Create";
         $actn = "Create";
         $sub2 = "New Invoice";
         $vorgid = $invdtl[0]['iBuyerOrganizationID'];
     } else {
         $sub1 = "Invoice Status Changed";
         $type = "Modified";
         $actn = $act;
         $sub2 = "Invoice Status Changed";
     }
Beispiel #3
0
         $acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
         $dt['iStatusID'] = $acptsts[0]['iStatusID'];
     } else {
         // $stsdtls =  $statusmasterObj->getDetails('*'," AND eFor='PO' AND vStatus_en='Issued' ");
         $dt['iStatusID'] = $isusts;
     }
 }
 $dt['iModifiedByID'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 // prints($dt); exit;
 $id = $pohObj->updateData($dt, " iPurchaseOrderID={$iPurchaseOrderID} ");
 $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
 $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
 // $vrfydt['eCreatedType'] = $_SESSION['SESS_'.PRJ_CONST_PREFIX.'_USER_TYPE_SHORT'];
 $vrfydt['dVerifyDate'] = calcGTzTime(date('Y-m-d H:i:s'), 'Y-m-d H:i:s');
 $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
 $res = $userActionObj->updateData($vrfydt, "iItemID={$id} AND eSubject='PO'");
 if ($id) {
     $isusts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Issued' ");
     if ($nstatus == $isusts[0]['iStatusID'] && ($podtl[0]['iInvoiceID'] == '' || $podtl[0]['iInvoiceID'] < 1)) {
         // $vInvoiceCode = $generalobj->getUniqueCode(PRJ_DB_PREFIX."_inovice_order_heading","vInvoiceCode");
         $povdt = $pohObj->select($iPurchaseOrderID);
         $splrorg = $orgObj->select($povdt[0]['iSupplierOrganizationID']);
         // New PO Acceptance
         $acptsts = $statusmasterObj->getDetails('*', " AND eFor='PO' AND vStatus_en='Accepted' ");
         $tusrs = $orgUsrObj->getPermittedUsers($povdt[0]['iSupplierOrganizationID'], $acptsts[0]['iStatusID'], 'po', 'acpt');
         $where = "AND vType='New PO Acceptance' AND eSection='Member'";
         $db_email = $emailObj->getDetails('*', $where);
         $link = SITE_URL_DUM . "purchaseorderview/" . $iPurchaseOrderID;
         $body = array("#POCODE#", "#SUPPLIERORG#", "#SUPORGCODE#", "#BUYERORG#", "#BUYORGCODE#", "#LINK#");
         $post = array($povdt[0]['vInvoiceCode'], $povdt[0]['vSupplierName'], $splrorg[0]['vOrganizationCode'], $povdt[0]['vBuyerCompanyName'], $povdt[0]['vBuyerCode'], $link);
         $rplarr = array("Hello #NAME#,", "background-color: rgb(239, 239, 239);", "Regards,", "#MAIL_FOOTER#", "#SITE_URL#");
Beispiel #4
0
         unset($updtdata[0]['iAsociationID']);
         $vdt = $updtdata[0];
         //prints($where);
         // prints($vdt); exit;
         $res = $orgAssocObj->updateData($vdt, $where);
         // echo "<br/>".$where; exit;
         //echo $where; exit;
         $udt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
         $udt['iVerifiedBy'] = $sess_id;
         $udt['dVerifyDate'] = date('Y-m-d H:i:s');
         $udt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
         // $udt['eNeedToVerify']='No';
         $userActionObj->setAllVar($udt);
         $where = " iItemID='" . $iVerifiedID . "' AND eSubject = 'Association'";
         // echo $where; exit;
         $res = $userActionObj->updateData($udt, $where);
         $where = "";
         unset($udt);
         //unset($vdt);
         //unset($dt);
         //						}
         //					}
         if ($res) {
             $msg = "rvs";
         } else {
             $msg = "rvserr";
         }
     }
 } else {
     //$where = "iAsociationID='".$updt[$ln]['iAsociationID']."'";
     //$orgAssocVerifyObj->updateData(array('eStatus'=>"Inactive"), $where);
Beispiel #5
0
        $updt['eStatus'] = $r2bdObj->chkAuctionBidStatus($iBidId);
        // pr($updt); exit;
        $res = $r2bdObj->updateData($updt, " iBidId={$iBidId} ");
        if ($res) {
            if ((!isset($dt[0]['eDelete']) || $dt[0]['eDelete'] != 'Yes') && $updt['eStatus'] == 'current') {
                $sub = 'New Bid For RFQ2';
            }
            $vrfydt['iVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_ID'];
            $vrfydt['eVerifiedBy'] = $_SESSION['SESS_' . PRJ_CONST_PREFIX . '_USER_TYPE_SHORT'];
            $vrfydt['dVerifyDate'] = calcGTzTime(date("Y-m-d H:i:s"), 'Y-m-d H:i:s');
            $vrfydt['vVerifyFromIP'] = $_SERVER['REMOTE_ADDR'];
            $vrfydt['vAction'] = 'Verify';
            $ivid = $userActionObj->getDetails('iVerifiedID', " AND iItemID={$iBidId} AND eSubject='RFQ2 Bid' ", " iVerifiedID DESC ");
            if (isset($ivid[0]['iVerifiedID']) && trim($ivid[0]['iVerifiedID']) != '' && $ivid[0]['iVerifiedID'] > 0) {
                $ivid = $ivid[0]['iVerifiedID'];
                $rs = $userActionObj->updateData($vrfydt, " iVerifiedID={$ivid} ");
            }
            $msg = "rvs";
        } else {
            $msg = "rver";
        }
    } else {
        $msg = "rver";
    }
} else {
    if ($view == 'reject' && trim($iBidId) != '' && $iBidId > 0) {
        $dtls = $r2bdObj->select($iBidId);
        $id = $iBidId;
        if (is_array($dtls) && count($dtls) > 0) {
            $updt['iRejectedBy'] = $sess_id;
            if (isset($dtls[0]['eDelete']) && $dtls[0]['eDelete'] == 'Yes') {