Guest User

Untitled

a guest
Feb 4th, 2014
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.78 KB | None | 0 0
  1. <?
  2. function save_data_target($dataarray,$userfile,$path_file_excel){
  3.  
  4. $user_group_id = $this->session->userdata('user_group_id');
  5. $cluster_id = $this->session->userdata('cluster_id');
  6. $region_id = $this->session->userdata('region_id');
  7. $created_on = date('Y-m-d H:i:s');
  8. $created_by = $this->session->userdata('user_id');
  9. $session_id = $this->session->userdata('session_id');
  10. $territory_id = $this->session->userdata('territory_type_id');
  11. $upload_date = date('Y-m-d H:i:s');
  12.  
  13. for($i=1;$i<count($dataarray);$i++){
  14. $data = array(
  15. 'region_name'=>$dataarray[$i]['region_name'],
  16. 'cluster'=>$dataarray[$i]['cluster'],
  17. 'nik'=>$dataarray[$i]['nik'],
  18. 'name'=>$dataarray[$i]['name'],
  19. 'kpi_code'=>$dataarray[$i]['kpi_code'],
  20. 'kpi_description'=>$dataarray[$i]['kpi_description'],
  21. 'type_incentive_id'=>$dataarray[$i]['type_incentive_id'],
  22. 'type_incentive'=>$dataarray[$i]['type_incentive'],
  23. 'chanel_code'=>$dataarray[$i]['chanel_code'],
  24. 'type_target_id'=>$dataarray[$i]['type_target_id'],
  25. 'type_target'=>$dataarray[$i]['type_target'],
  26. 'target'=>$dataarray[$i]['target'],
  27. 'month'=>$dataarray[$i]['month'],
  28. 'year'=>$dataarray[$i]['year'],
  29. 'upload_date'=>$upload_date,
  30.  
  31. 'created_by'=>$this->session->userdata('user_id'),
  32. 'territory_id'=>$territory_id,
  33. 'created_on'=>$created_on,
  34. 'user_group_id'=>0,
  35. 'cluster_id'=>1,
  36. 'region_id'=>1,
  37. 'session_id'=>$session_id,
  38. 'nama_file_excel'=>$userfile,
  39. 'path_file_excel'=>$path_file_excel
  40. );
  41. $this->db->insert('nama_tabel', $data);
  42. }
  43.  
  44. }
  45. ?>
  46.  
  47. // bagaimana cara penulisan trim() sebelum insert ke tabel ?
  48. // saya mau trim() pada kolom nik -> 'nik'=>$dataarray[$i]['nik'],
  49.  
  50. terima kasih
Advertisement
Add Comment
Please, Sign In to add comment