Langsung ke konten utama

Call procedure input param

 $srv_req_id          = $data['srv_req_id'] ;
 $employee_id         = $data['employee_id'];
 $user_id             = $data['user_id'];  
 
 $result['status']  = TRUE;
 $result['message']  = 'Sukses assigned Ticket ke employee';
 
 try{
   $sql = "CALL SMS_SP_SPKTS_AssignedTo($srv_req_id,$employee_id,$user_id)";    
   $stmt  = oci_parse($this->db->conn_id, $sql);    
  
  if(@!oci_execute($stmt)){
   $err = oci_error($stmt);
   
   throw new Exception($err['message']);
  }
  
 
 }  
 catch (Exception $e) {

 
  $result['status']   = FALSE;
  $result['message']  = $e->getMessage(); 
 
 
 }
 return $result; 

Komentar

Popular Posts

Render tips pada event render

render: function(p) { var theElem = p.getEl(); var theTip = Ext.create('Ext.tip.Tip', { html: 'Tuliskan Sequent Number atau Telephone Number atau Office Number atau Mobile Number atau Customer Number ', margin: '0 0 0 300', shadow: false }); p.getEl().on('mouseover', function(){ theTip.showAt(theElem.getX(), theElem.getY()); }); p.getEl().on('mouseleave', function(){ theTip.hide(); }); }

Menambahkan Item Id untuk HTML Attribut

{ 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...