function insert_out_call($data)
{
$vPromo_Id = $data['vPromo_Id'];
$pCategory_Id = $data['pCategory_Id'];
$pMesssage = $data['pMesssage'];
$pCreated_By = $data['pCreated_By'];
$vCall_Id = '';
try{
$sql = "CALL sp_Insert_Mncshop_Out_Call(:vPromo_Id,:pCategory_Id,:pMesssage,:pCreated_By,:vCall_Id)";
$stmt = oci_parse($this->db->conn_id, $sql);
// Bind the input parameter
oci_bind_by_name($stmt,':vPromo_Id',$vPromo_Id);
oci_bind_by_name($stmt,':pCategory_Id',$pCategory_Id);
oci_bind_by_name($stmt,':pMesssage',$pMesssage);
oci_bind_by_name($stmt,':pCreated_By',$pCreated_By);
// Bind the output parameter
oci_bind_by_name($stmt,':vCall_Id',$vCall_Id);
if(@!oci_execute($stmt)){
$err = oci_error($stmt);
throw new Exception($err['message']);
}
}
catch (Exception $e) {
$result['status'] = FALSE;
$result['message'] = $e->getMessage();
}
$result['status'] = TRUE;
$result['message'] = 'Sukses Insert Outbound Call ID : ' .$vCall_Id;
return $result;
}
{ border:false, frame:false, width: 225, margin: '5px 0px 10px 9px', items: [{ xtype : 'textfield', fieldLabel : 'Telephone', inputType :'password', id : 'telephone', inputId: 'item_telepon', width: 225, readOnly : true, fieldStyle :'background-image:none;background-color:#BDBDBD', },{ xtype : 'textfield', fieldLabel : 'Office no', inputType :'password', width: 225, id :'office_no', inputId: 'item_office_no', readOnly : true, fieldStyle :'background-image:none;background-color:#BDBDBD', },{ xtype : 'textfield', fieldLabel : 'Mobile no', inputType :'password', width: 225, id:'mobile_no', inputId: 'item_mobile_no', readOnly : true, fieldStyle :'back...
Komentar
Posting Komentar