Web Development

Custom save function vTiger module

vTiger

Rochek Stories |12.Dec.2020

Generally vTiger provides save_module , save function for saving records.But let say you have a deposit module and you want custom function for saving records in vTiger (6.4). basically deposit module has relation with Account module. so in vTiger vtiger_crmentity table maintain every records or operation done and vtiger_crmentity_seq store max id or sequence number , so below are the functions which process save functionality by using custom queries for two modules.

									     
function save_module_custom($module, $post_array) {
    return $this->insertIntoDepositTable('vtiger_deposit', $module, $post_array);
}										
									

									     
function insertIntoDepositTable($table_name, $module, $post_array) {
    global $log, $adb;
    $log->info("in insertIntoDepositTable  " . $table_name . "    module is  " . $module);
    $payment_method = $post_array['payment_method'];
    $account_no = $post_array['account_no'];
    $amount = $post_array['amount'];
    $account_id = $post_array['account_id'];
    $order_id = $this->gen_uuid();
    $currency = 'USD';
    $createdtime = date('Y-m-d H:i:s');
    $assigned_user_id = getRecordOwnerId($post_array['customer_id']);
    $id = $this->getMaxId();
    $deposit_status = 'Pending';
    $comment = '';
    $sql = "INSERT INTO vtiger_deposit(depositid, currency, payment_method, amount, account_id, 
    deposit_status ,order_id,comment) ". "VALUES ($id,'" . $currency . "','" . $payment_method . "','" . $amount . "','" . $account_id . "', '" . $deposit_status . "','" . $order_id . "','" . $comment . "')";
    $adb->pquery($sql, array());
    $sql = "INSERT INTO vtiger_depositcf(depositid) ". "VALUES ($id)";
    $adb->pquery($sql, array());
    $crmid = $this->custom_save_related_module($id, $account_no, $assigned_user_id);
    return array('depositid' => $id, 'crmid' => $crmid);
}										
									

									     
function custom_save_related_module($relcrmid, $account_no, $assigned_user_id) {
        global $log, $adb;
        $log->info("in custom_save_related_module  vtiger_crmentity,vtiger_crmentity_seq");
        //First get seq no max
        $getCrmSqNo = $adb->pquery("SELECT id FROM vtiger_crmentity_seq", array());
        $norows = $adb->num_rows($res);
        $seq_id = $adb->query_result($getCrmSqNo, 0, 'id');
        $seq_id = $seq_id + 1;
        $adb->pquery("Update vtiger_crmentity_seq set id='$seq_id'", array());
        $liveaccountinfo = $adb->pquery("SELECT liveaccountid FROM vtiger_liveaccount 
 where account_no=?", array($mt4_account_no));
        $norows = $adb->num_rows($liveaccountinfo);
        $liveaccountid = $adb->query_result($liveaccountinfo, 0, 'liveaccountid');
        $module = 'Deposit';
        $with_module = 'Account';
        $adb->pquery("INSERT INTO vtiger_crmentityrel(crmid, module, relcrmid, relmodule) 
 VALUES(?,?,?,?)", Array($liveaccountid, $module, $relcrmid, $with_module));
        $adb->pquery("INSERT INTO vtiger_crmentity(crmid , setype, createdtime, modifiedtime,label 
 , smcreatorid , smownerid) 
 VALUES(?,?,?,?,?,?,?)", Array($seq_id, $module, date('Y-m-d H:i:s'), date('Y-m-d H:i:s'), 
 $liveaccountid, 
 $assigned_user_id, $assigned_user_id));
        return $seq_id;
    }										
									

									     
function gen_uuid() {
    global $adb;
    $order_id = NULL;
    $res = $adb->pquery("SELECT uuid() As order_id", array());
    $norows = $adb->num_rows($res);
    if ($norows > 0) {
        $order_id = $adb->query_result($res, 0, 'order_id');
        $order_id = str_replace('-', '', $order_id);
    }
    return $order_id;
}										
									

Below function get max id from your custom table because we can put this id to reference table for maintaining relationship.

									     
function gen_uuid() {
    global $adb;
    $order_id = NULL;
    $res = $adb->pquery("SELECT uuid() As order_id", array());
    $norows = $adb->num_rows($res);
    if ($norows > 0) {
        $order_id = $adb->query_result($res, 0, 'order_id');
        $order_id = str_replace('-', '', $order_id);
    }
    return $order_id;
}