PageRenderTime 61ms CodeModel.GetById 24ms RepoModel.GetById 0ms app.codeStats 1ms

/app/Controller/WorksController.php

https://bitbucket.org/dosm123/crm
PHP | 710 lines | 652 code | 33 blank | 25 comment | 211 complexity | fac5ebc2e67fe5af17badd78b275e90a MD5 | raw file
Possible License(s): LGPL-3.0, GPL-3.0, LGPL-2.1 
    

  1. <?php
    2. 

  2. 

  3. class WorksController extends AppController{
    4. 

  4.   public $paginate = array( 
    5. 

  5. 			   'limit' => 25,
    6. 

  6. 			   'order' => array(
    7. 

  7. 					    'Complain.reg_date' => 'desc'
    8. 

  8. 					    ),
    9. 

  9. 			   'recursive' => 2,
    10. 

  10. 			    );
    11. 

  11.   public $name = 'Works';
    12. 

  12. 

  13.   public function index(){
    14. 

  14.     $this->loadModel('Board');
    15. 

  15.     $this->loadModel('Life');
    16. 

  16.     $this->loadmodel('User');
    17. 

  17.     $this->loadmodel('UserInfo');
    18. 

  18.     $this->loadmodel('Complex');
    19. 

  19.     $this->loadmodel('Complain');
    20. 

  20.     $this->loadModel('TopCategory');
    21. 

  21.     $this->loadModel('MidCategory');
    22. 

  22.     $this->loadModel('BottomCategory');
    23. 

  23.     $this->set('tops', $this->TopCategory->find('all'));
    24. 

  24.     $this->set('mids', $this->TopCategory->MidCategory->find('all'));
    25. 

  25.     $data = null;
    26. 

  26.     $conditions = array();
    27. 

  27.     $conditions['not'] = array('Complain.status' => 0);
    28. 

  28.     if($this->request->query){
    29. 

  29.       $data = $this->request->query['data'];
    30. 

  30.       $type = $data['Search']['type'];
    31. 

  31.       $input = $data['Search']['keyword'];
    32. 

  32.       if($type == "name"){
    33. 

  33. 	$complex = array_keys($this->Complex->find('list', array('conditions' => array('Complex.name LIKE' => "%$input%"))));
    34. 

  34. 	$conditions = array('or'=> array('Board.complex_id' => $complex,
    35. 

  35. 					 'Life.complex_id' => $complex));
    36. 

  36.       }
    37. 

  37.       else if($type == "serial" || $type == "mac") {
    38. 

  38. 	$conditions = array("or" => array("Board.$type LIKE" => "%$input%",
    39. 

  39. 					  "Life.$type LIKE" => "%$input%"));
    40. 

  40.       }
    41. 

  41.       else if($type == "engineer") {
    42. 

  42.         $userinfo = array_keys($this->UserInfo->find('list', array('conditions' => array('UserInfo.name LIKE' => "%$input%"))));
    43. 

  43. 	$conditions = array("Complain.engineer_id" => $userinfo);
    44. 

  44.       }
    45. 

  45.       else {
    46. 

  46. 	$conditions = array("Complain.$type LIKE" => "%$input%");
    47. 

  47.       }
    48. 

  48.       if(!isset($data['Filter'])){
    49. 

  49. 	$data['Filter'] = array('midcategory' => 'default', 'topcategory' => 'default',  'status' => 'default',  'method' => 'default', 'region_name' => 'default', 'media' => 'default');
    50. 

  50.       }
    51. 

  51. 

  52.       foreach ( array_keys($data['Filter']) as $key) {
    53. 

  53. 	if($data['Filter'][$key] != "default"){
    54. 

  54. 	  // need a special process for foreignKeys
    55. 

  55. 	  if($key == 'method'){
    56. 

  56. 	    $conditions['or'] = array('Board.method' => $data['Filter'][$key],
    57. 

  57. 				      'Life.method' => $data['Filter'][$key]);
    58. 

  58. 	  }
    59. 

  59. 	  else if($key == 'region_name'){
    60. 

  60. 	    $ids = array_keys($this->Complex->find('list', array('conditions'=>array('region_name'=>$data['Filter']['region_name']))));
    61. 

  61. 	    $conditions['or']['Board.complex_id'] = $ids;
    62. 

  62. 	    $conditions['or']['Life.complex_id'] = $ids;
    63. 

  63. 	  }
    64. 

  64. 	  else if($key == 'topcategory' || $key == 'midcategory'){
    65. 

  65. 	    $tmp_cond = null;
    66. 

  66. 	    if($data['Filter']['topcategory'] != 'default' and $data['Filter']['midcategory'] != 'default'){
    67. 

  67. 	      $top_ids = array_keys($this->BottomCategory->TopCategory->find('list', array('conditions' => array('category' => $data['Filter']['topcategory']))));
    68. 

  68. 	      $mid_ids = array_keys($this->BottomCategory->MidCategory->find('list', array('conditions' => array('category' => $data['Filter']['midcategory']))));
    69. 

  69. 	      $tmp_cond = array('top_category_id' => $top_ids,
    70. 

  70. 				'mid_category_id' => $mid_ids);
    71. 

  71. 	    }
    72. 

  72. 	    else if($data['Filter']['topcategory'] != 'default'){
    73. 

  73. 	      $top_ids = array_keys($this->BottomCategory->TopCategory->find('list', array('conditions' => array('category' => $data['Filter']['topcategory']))));
    74. 

  74. 	      $tmp_cond = array('top_category_id' => $top_ids);
    75. 

  75. 	    }
    76. 

  76. 	    else if($data['Filter']['midcategory'] != 'default'){
    77. 

  77. 	      $mid_ids = array_keys($this->BottomCategory->MidCategory->find('list', array('conditions' => array('category' => $data['Filter']['midcategory']))));
    78. 

  78. 	      $tmp_cond = array('mid_category_id' => $mid_ids);
    79. 

  79. 	    }
    80. 

  80. 	    $bottoms = array_keys($this->BottomCategory->find('list', array('conditions'=>$tmp_cond)));
    81. 

  81. 	    $conditions['Complain.cs_bottom_category_id'] = $bottoms;
    82. 

  82. 	  }
    83. 

  83. 	  else if($key == 'media'){
    84. 

  84. 	    if($data['Filter']['media'] == '보드'){
    85. 

  85. 	      $conditions['Complain.board_id <>'] = NULL;
    86. 

  86. 	    }
    87. 

  87. 	    else if ($data['Filter']['media'] == '라이프'){
    88. 

  88. 	      $conditions['Complain.life_id <>'] = NULL;
    89. 

  89. 	    }
    90. 

  90. 	  }
    91. 

  91. 	  else if($key == 'status'){
    92. 

  92. 	    if($data['Filter']['status'] == '0'){
    93. 

  93. 	      $conditions['Complain.status'] = 0;
    94. 

  94. 	    }
    95. 

  95. 	    else if ($data['Filter']['status'] == '1'){
    96. 

  96. 	      $conditions['Complain.status'] = 1;
    97. 

  97. 	    }
    98. 

  98. 	    else if ($data['Filter']['status'] == '2'){
    99. 

  99. 	      $conditions['Complain.status'] = 2;
    100. 

  100. 	    }
    101. 

  101. 	    else if ($data['Filter']['status'] == '3'){
    102. 

  102. 	      $conditions['Complain.status'] = 3;
    103. 

  103. 	    }
    104. 

  104. 	  }
    105. 

  105. 	  else if($key == 'start_date'){
    106. 

  106. 	        if($data['Filter'][$key]){
    107. 

  107. 			$date = date('Y-m-d', strtotime($data['Filter'][$key]));
    108. 

  108. 			$conditions['Complain.end_date >='] = $date;
    109. 

  109. 		}
    110. 

  110. 	  }
    111. 

  111. 	  else if($key == 'end_date'){
    112. 

  112. 	        if($data['Filter'][$key]){
    113. 

  113. 			$date = date('Y-m-d', strtotime($data['Filter'][$key]) + 86400);
    114. 

  114. 		     	$conditions['Complain.end_date <='] = $date;
    115. 

  115. 		}
    116. 

  116. 	  }
    117. 

  117. 	}
    118. 

  118.       }
    119. 

  119.       // 검색 혹은 필터 내용 있으면 검색 처리
    120. 

  120.     }
    121. 

  121.     $conditions['not'] = array('Complain.status' => 0);
    122. 

  122.     $this->paginate['conditions'] = $conditions;
    123. 

  123.     /* paginate 때문에 붙인거 */
    124. 

  124.     $this->Complain->unbindModel(array('hasMany' => array('Cs')));
    125. 

  125.     $this->Complain->EngineerInfo->unbindModel(array('hasOne'=> array('User'), 'hasMany' => array('Complex', 'Complain')));
    126. 

  126.     $this->Complain->ReceiverInfo->unbindModel(array('hasOne'=> array('User'), 'hasMany' => array('Complex', 'Complain')));
    127. 

  127.     $this->Board->unbindModel(array('hasMany' => array('Complain')));
    128. 

  128.     $this->Life->unbindModel(array('hasMany' => array('Complain')));
    129. 

  129.     $this->set('complains', $this->paginate('Complain'));
    130. 

  130.     $this->set('medias', array('보드', '라이프'));
    131. 

  131.     $this->set('methods', Set::extract('/boards/method', $this->Board->query('select distinct method from boards')));
    132. 

  132.     $this->set('regions' , Set::extract('/complexes/region_name', $this->Complex->query('select distinct region_name from complexes')));
    133. 

  133.     $this->set('topcategories' , Set::extract('/top_categories/category', $this->TopCategory->query('select distinct category from top_categories')));
    134. 

  134.     
    135. 

  135.     $this->set('midcategories', Set::extract('/mid_categories/category', $this->MidCategory->query('select distinct category from mid_categories')));
    136. 

  136.     /* $this->set('methods', array_unique( */
    137. 

  137.     /* 				       array_merge(Set::extract('/Board/method', $complains), */
    138. 

  138.     /* 						   Set::extract('/Life/method', $complains)) */
    139. 

  139.     /* 				       ) */
    140. 

  140.     /* 	       ); */
    141. 

  141.     /* $this->set('regions', array_unique( */
    142. 

  142.     /* 				      array_merge(Set::extract('/Board/Complex/region_name', $complains), */
    143. 

  143.     /* 				      Set::extract('/Life/Complex/region_name', $complains)) */
    144. 

  144.     /* 				      )); */
    145. 

  145.     /* $this->set('topcategories', array_unique(Set::extract('/CsBottomCategory/TopCategory/category', $complains))); */
    146. 

  146.     /* $this->set('midcategories', array_unique(Set::extract('/CsBottomCategory/MidCategory/category', $complains))); */
    147. 

  147.     $this->set('searchinfo', $data);
    148. 

  148.   }
    149. 

  149.   public function add($media, $media_id, $complain_id){
    150. 

  150.     $this->loadModel('Cs');
    151. 

  151.     $this->loadModel('Life');
    152. 

  152.     $this->loadModel('Board');
    153. 

  153.     $this->loadModel('TopCategory');
    154. 

  154.     $this->loadModel('Complain');
    155. 

  155.     $this->set('tops', $this->TopCategory->find('all'));
    156. 

  156.     $this->set('mids', $this->TopCategory->MidCategory->find('all'));
    157. 

  157.     $this->set('bottoms', $this->TopCategory->MidCategory->BottomCategory->find('all'));
    158. 

  158.     $this->set('media', $media);
    159. 

  159.     $this->set('media_id', $media_id);
    160. 

  160.     if($media == 'life'){
    161. 

  161.     	      $life = $this->Life->findById($media_id);
    162. 

  162. 	      $complex_id = $life['Life']['complex_id'];
    163. 

  163.     }
    164. 

  164.     else if($media == 'board'){
    165. 

  165.     	      $board = $this->Board->findById($media_id);
    166. 

  166. 	      $complex_id = $board['Board']['complex_id'];
    167. 

  167.     }
    168. 

  168.     $this->set('complex_id', $complex_id);
    169. 

  169.     $this->set('complain', $this->Complain->findById($complain_id, array('recursive' => 0)));
    170. 

  170.     $this->set('complain_id', $complain_id);
    171. 

  171.   }
    172. 

  172.   public function edit($media, $media_id, $complain_id, $cs_id){
    173. 

  173.     $this->loadModel('Cs');
    174. 

  174.     $this->loadModel('Life');
    175. 

  175.     $this->loadModel('Board');
    176. 

  176.     $this->loadModel('TopCategory');
    177. 

  177.     $this->loadModel('CsMaterial');
    178. 

  178.     $this->loadModel('CsAdditionalInfo');
    179. 

  179.     $this->loadModel('Complain');
    180. 

  180.     $this->loadModel('User');
    181. 

  181.     $this->set('users', $this->User->find('all'));
    182. 

  182.     $this->set('media', $media);
    183. 

  183.     $this->set('media_id', $media_id);
    184. 

  184.     if($media == 'life'){
    185. 

  185.     	      $life = $this->Life->findById($media_id);
    186. 

  186. 	      $complex_id = $life['Life']['complex_id'];
    187. 

  187.     }
    188. 

  188.     else if($media == 'board'){
    189. 

  189.     	      $board = $this->Board->findById($media_id);
    190. 

  190. 	      $complex_id = $board['Board']['complex_id'];
    191. 

  191.     }
    192. 

  192.     $this->set('complex_id', $complex_id);
    193. 

  193.     $cs = $this->Cs->findById($cs_id);
    194. 

  194.     $this->set('complain_id', $cs['Complain']['id']);
    195. 

  195.     $this->set('tops', $this->TopCategory->find('all' , array('conditions' => array('TopCategory.deleted' => 0))));
    196. 

  196.     $this->set('mids', $this->TopCategory->MidCategory->find('all', array('conditions' => array('MidCategory.deleted' => 0))));
    197. 

  197.     $this->set('bottoms', $this->TopCategory->MidCategory->BottomCategory->find('all', array('conditions' => array('BottomCategory.deleted' => 0))));
    198. 

  198.     $this->set('cs', $cs);
    199. 

  199.     $this->set('cs_id', $cs_id);
    200. 

  200.     $this->set('csMaterials', $this->CsMaterial->find('all', array('conditions' =>array('CsMaterial.cs_id' => $cs_id) )));
    201. 

  201.     $this->set('csAdditions', $this->CsAdditionalInfo->find('all', array('conditions' =>array('CsAdditionalInfo.cs_id' => $cs_id))));
    202. 

  202.     if($this->request->is('post')){
    203. 

  203. 	$this->Cs->id = $cs_id;
    204. 

  204. 	$cs['Cs']['comment'] = parent::eucconv($cs['Cs']['comment']);
    205. 

  205. 	if($cs['Cs']['bottom_category_id'] == "default"){
    206. 

  206. 	  $cs['Cs']['bottom_category_id'] = 1;
    207. 

  207. 	}
    208. 

  208. 	if($this->Cs->save($this->request->data['Cs'])){
    209. 

  209. 	if(!parent::array_empty($this->request->data['CsMaterial'])){
    210. 

  210. 	   foreach( $this->request->data['CsMaterial'] as $csMaterial):
    211. 

  211. 	       if(!parent::array_empty($csMaterial)){
    212. 

  212. 	           if($csMaterial['cs_id'] == null){
    213. 

  213. 		      $csMaterial['cs_id'] = $cs_id;
    214. 

  214. 		   }
    215. 

  215. 	       	   $this->CsMaterial->saveAll($csMaterial);
    216. 

  216. 	       }
    217. 

  217. 	   endforeach;
    218. 

  218. 	}
    219. 

  219.         if(!parent::array_empty($this->request->data['CsAdditionalInfo'])){
    220. 

  220. 	   foreach( $this->request->data['CsAdditionalInfo'] as $csAddition):
    221. 

  221. 	      if(!parent::array_empty($csAddition)){
    222. 

  222. 	           if($csAddition['cs_id'] == null){
    223. 

  223. 		      $csAddition['cs_id'] = $cs_id;
    224. 

  224. 		   }
    225. 

  225. 		  $this->CsAdditionalInfo->saveAll($csAddition);
    226. 

  226. 	      }
    227. 

  227. 	   endforeach;
    228. 

  228. 	}  
    229. 

  229. 	$thisComplain = $this->Complain->findById($this->request->data['Complain']['id']);	 
    230. 

  230. 	$thisComplain['Complain']['cs_bottom_category_id'] = $this->request->data['Cs']['bottom_category_id'];
    231. 

  231.     	if($this->request->data['Complain']['status'] == 2){
    232. 

  232. 	     $thisComplain['Complain']['status'] = $complain['status'];
    233. 

  233. 	     $thisComplain['Complain']['engineer_id'] = $this->request->data['Complain']['engineer_id'];
    234. 

  234. 	}
    235. 

  235.         $this->Complain->save($thisComplain);
    236. 

  236. 	   $this->redirect('/complains/view/'.$media.'/'.$media_id.'/'.$complain_id);
    237. 

  237. 	}
    238. 

  238.     }
    239. 

  239.   }
    240. 

  240. 

  241.   public function ajaxMod($complain_id){
    242. 

  242.     $this->loadModel('Compain');
    243. 

  243.     $this->loadModel('Cs');
    244. 

  244.     $this->loadModel('CsMaterial');
    245. 

  245.     $this->loadModel('CsAdditionalInfo');
    246. 

  246.     if($this->request->is('post')){
    247. 

  247.       $deleted_materials = $this->request->data['deleted_material_id'];
    248. 

  248.       $deleted_additions = $this->request->data['deleted_addition_id'];
    249. 

  249.       if($deleted_materials){
    250. 

  250. 	$materials = split(',', $deleted_materials);
    251. 

  251. 	for($i = 0; $i < count($materials) - 1; $i++){
    252. 

  252. 	  $this->CsMaterial->delete($materials[$i]);
    253. 

  253. 	}
    254. 

  254.       }
    255. 

  255.       if($deleted_additions){
    256. 

  256. 	$additions = split(',', $deleted_additions);
    257. 

  257. 	for($i = 0; $i < count($additions) - 1; $i++){
    258. 

  258. 	  $this->CsAdditionalInfo->delete($additions[$i]);
    259. 

  259. 	}
    260. 

  260.       }
    261. 

  261.       $cs = $this->request->data['Cs'];
    262. 

  262.          $thisCs = $this->Cs->findById($cs['id']);
    263. 

  263.          $thisCs['Cs']['comment'] = parent::eucconv($cs['comment']);
    264. 

  264. 	 $thisCs['Cs']['oil'] = $cs['oil'];
    265. 

  265. 	 $thisCs['Cs']['time'] = $cs['time'];
    266. 

  266. 	 $thisCs['Cs']['bottom_category_id'] = $cs['bottom_category_id'];
    267. 

  267. 	 if($cs['bottom_category_id'] == "default"){
    268. 

  268. 	   $thisCs['Cs']['bottom_category_id'] = 1;
    269. 

  269. 	 }
    270. 

  270.       if($this->Cs->save($thisCs)){
    271. 

  271.         if(!parent::array_empty($this->request->data['CsMaterial'])){
    272. 

  272. 	   foreach( $this->request->data['CsMaterial'] as $csMaterial):
    273. 

  273. 	       if(!parent::array_empty($csMaterial)){
    274. 

  274. 	           $csMaterial['cs_id'] = $cs['id'];
    275. 

  275. 	       	   $this->CsMaterial->saveAll($csMaterial);
    276. 

  276. 	       }
    277. 

  277. 	   endforeach;
    278. 

  278. 	}
    279. 

  279.         if(!parent::array_empty($this->request->data['CsAdditionalInfo'])){
    280. 

  280. 	   foreach( $this->request->data['CsAdditionalInfo'] as $csAddition):
    281. 

  281. 	      if(!parent::array_empty($csAddition)){
    282. 

  282. 	          $csAddition['cs_id'] = $cs['id'];
    283. 

  283. 	      	  $csAddition['name'] = parent::eucconv($csAddition['name']);
    284. 

  284. 		  $this->CsAdditionalInfo->saveAll($csAddition);
    285. 

  285. 	      }
    286. 

  286. 	   endforeach;
    287. 

  287. 	}
    288. 

  288. 	$complain = $this->request->data['Complain'];
    289. 

  289. 	if($this->request->data['Cs']['bottom_category_id'] == 'default'){
    290. 

  290. 	  $this->request->data['Cs']['bottom_category_id'] = 1;
    291. 

  291. 	}
    292. 

  292.         $thisComplain = $this->Complain->findById($complain_id);
    293. 

  293.       	 if($complain['status'] == 2){
    294. 

  294. 	     $thisComplain['Complain']['engineer_id'] = $complain['0']['engineer_id'];
    295. 

  295. 	 }
    296. 

  296.       	 else if($complain['status'] == 3){
    297. 

  297. 	     $thisComplain['Complain']['end_date'] = date('Y-m-d H:i', strtotime('now'));	 
    298. 

  298. 	 }
    299. 

  299. 	     $thisComplain['Complain']['status'] = $complain['status'];
    300. 

  300. 	     $thisComplain['Complain']['cs_bottom_category_id'] = $thisCs['Cs']['bottom_category_id'];
    301. 

  301. 	     $this->Complain->save($thisComplain);
    302. 

  302. 	echo 'good';
    303. 

  303.       }
    304. 

  304.       else{
    305. 

  305. 	echo 'bad';
    306. 

  306.       }
    307. 

  307.     }
    308. 

  308.     $this->render('/works/ajaxMod', 'ajax');
    309. 

  309.   }
    310. 

  310.   public function ajaxAdd($complain_id){
    311. 

  311.     $this->loadModel('Compain');
    312. 

  312.     $this->loadModel('Cs');
    313. 

  313.     $this->loadModel('CsMaterial');
    314. 

  314.     $this->loadModel('CsAdditionalInfo');
    315. 

  315.     if($this->request->is('post')){
    316. 

  316. 	foreach($this->request->data['Complain'] as $complain){
    317. 

  317. 	 $thisComplain = $this->Complain->findById($complain_id);
    318. 

  318. 	 $thisComplain['Complain']['status'] = $complain['status'];
    319. 

  319. 	 if($this->request->data['Cs']['0']['bottom_category_id'] == 'default'){
    320. 

  320. 	    $this->request->data['Cs']['0']['bottom_category_id'] = 1;
    321. 

  321. 	 }
    322. 

  322. 	 $thisComplain['Complain']['cs_bottom_category_id'] = $this->request->data['Cs']['0']['bottom_category_id'];
    323. 

  323.       	 if($complain['status'] == 2){
    324. 

  324. 	     $thisComplain['Complain']['engineer_id'] = $complain['engineer_id'];
    325. 

  325. 	 }
    326. 

  326.       	 else if($complain['status'] == 3){
    327. 

  327. 	     $thisComplain['Complain']['end_date'] = date('Y-m-d H:i', strtotime('now'));	 
    328. 

  328. 	 }
    329. 

  329. 	 $this->Complain->save($thisComplain);
    330. 

  330. 	 }
    331. 

  331.       foreach( $this->request->data['Cs'] as $cs) :
    332. 

  332.          $cs['comment'] = parent::eucconv($cs['comment']);
    333. 

  333. 	 if($cs['bottom_category_id'] == "default"){
    334. 

  334. 	   $cs['bottom_category_id'] = 1;
    335. 

  335. 	 }
    336. 

  336.       if($this->Cs->save($cs)){
    337. 

  337.         if(!parent::array_empty($this->request->data['CsMaterial'])){
    338. 

  338. 	   foreach( $this->request->data['CsMaterial'] as $csMaterial):
    339. 

  339. 	       if(!parent::array_empty($csMaterial)){
    340. 

  340. 	           $csMaterial['cs_id'] = $this->Cs->getLastInsertId();
    341. 

  341. 	       	   $this->CsMaterial->saveAll($csMaterial);
    342. 

  342. 	       }
    343. 

  343. 	   endforeach;
    344. 

  344. 	}
    345. 

  345.         if(!parent::array_empty($this->request->data['CsAdditionalInfo'])){
    346. 

  346. 	   foreach( $this->request->data['CsAdditionalInfo'] as $csAddition):
    347. 

  347. 	      if(!parent::array_empty($csAddition)){
    348. 

  348. 	          $csAddition['cs_id'] = $this->Cs->getLastInsertId();
    349. 

  349. 	      	  $csAddition['name'] = parent::eucconv($csAddition['name']);
    350. 

  350. 		  $this->CsAdditionalInfo->saveAll($csAddition);
    351. 

  351. 	      }
    352. 

  352. 	   endforeach;
    353. 

  353. 	}
    354. 

  354. 	echo 'good';
    355. 

  355.       }
    356. 

  356.       else{
    357. 

  357. 	echo 'bad';
    358. 

  358.       }
    359. 

  359.       endforeach;
    360. 

  360.     }
    361. 

  361.     $this->render('/works/ajaxAdd', 'ajax');
    362. 

  362.   }
    363. 

  363.   public function delete($cs_id ){
    364. 

  364.      $this->loadModel('Complain');
    365. 

  365.      $this->loadModel('Cs');
    366. 

  366.      $this->loadModel('Life');
    367. 

  367.      $this->loadModel('Board');
    368. 

  368.      $cs = $this->Cs->findById($cs_id);
    369. 

  369.      $complain = $this->Complain->findById($cs['Cs']['complain_id']);
    370. 

  370.      if(!parent::array_empty($complain['Life'])){
    371. 

  371. 	  $boardlife = $this->Life->findById($complain['Complain']['life_id']);
    372. 

  372. 	  $boardlife['style'] = 'life';
    373. 

  373. 	  $boardlife_id = $boardlife['Life']['id'];
    374. 

  374.      }
    375. 

  375.      else if(!parent::array_empty($complain['Board'])){
    376. 

  376. 	  $boardlife = $this->Board->findById($complain['Complain']['board_id']);
    377. 

  377. 	  $boardlife['style'] = 'board';
    378. 

  378. 	  $boardlife_id = $boardlife['Board']['id'];
    379. 

  379.      }
    380. 

  380.      $this->Cs->id = $cs['Cs']['id'];
    381. 

  381.      if($this->Cs->delete()){
    382. 

  382.        $this->redirect('/complains/view/'.$boardlife['style'].'/'.$boardlife_id.'/'.$complain['Complain']['id']);
    383. 

  383.      }
    384. 

  384. 

  385.   }
    386. 

  386.   public function ajaxAdd2(){
    387. 

  387.     $this->loadModel('Complain');
    388. 

  388.     $this->loadModel('Cs');
    389. 

  389.     $this->loadModel('CsMaterial');
    390. 

  390.     $this->loadModel('CsAdditionalInfo');
    391. 

  391.     if($this->request->is('post')){
    392. 

  392.       foreach( $this->request->data['Complain'] as $complain):
    393. 

  393.          if($complain['media'] == 'board'){
    394. 

  394. 	     $complain['board_id'] = $complain['device_id'];
    395. 

  395. 	 }
    396. 

  396. 	 else if($complain['media'] == 'life'){
    397. 

  397. 	     $complain['life_id'] = $complain['device_id'];
    398. 

  398. 	 }
    399. 

  399.          $complain['title'] = parent::eucconv($complain['title']);
    400. 

  400.          $complain['name'] = parent::eucconv($complain['name']);
    401. 

  401.          $complain['comment'] = parent::eucconv($complain['comment']);
    402. 

  402. 	 $complain['bottom_category_id'] = 1;
    403. 

  403. 	 if($complain['status'] == 3)
    404. 

  404. 	   $complain['end_date'] = date('Y-m-d H:i:s');
    405. 

  405. 	 if($this->Complain->save($complain)){
    406. 

  406. 	     foreach($this->request->data['Cs'] as $cs):
    407. 

  407. 		 if($cs['bottom_category_id'] == 'default'){
    408. 

  408. 		     $cs['bottom_category_id'] = 1;
    409. 

  409. 		 }
    410. 

  410. 		 $cs['complain_id'] = $this->Complain->getLastInsertId();
    411. 

  411. 		 $cs['user_info_id'] = $complain['engineer_id'];
    412. 

  412. 	         $cs['created'] = $complain['reg_date'];
    413. 

  413. 	         $cs['comment'] = $complain['comment'];
    414. 

  414. 		 $nComplain = $this->Complain->findById($this->Complain->getLastInsertId());
    415. 

  415. 

  416. 		 $nComplain['Complain']['cs_bottom_category_id'] = $cs['bottom_category_id'];
    417. 

  417. 		 $this->Complain->save($nComplain);
    418. 

  418. 		 if($this->Cs->save($cs)){
    419. 

  419. 		     if(!parent::array_empty($this->request->data['CsMaterial'])){
    420. 

  420. 		         foreach( $this->request->data['CsMaterial'] as $csMaterial):
    421. 

  421. 			     $csMaterial['cs_id'] = $this->Cs->getLastInsertId();
    422. 

  422. 			     $this->CsMaterial->saveAll($csMaterial);
    423. 

  423. 			 endforeach;
    424. 

  424. 	             }
    425. 

  425. 		     if(!parent::array_empty($this->request->data['CsAdditionalInfo'])){
    426. 

  426. 		     	 foreach( $this->request->data['CsAdditionalInfo'] as $csAddition):
    427. 

  427. 			     $csAddition['cs_id'] = $this->Cs->getLastInsertId();
    428. 

  428. 			     $csAddition['name'] = parent::eucconv($csAddition['name']);
    429. 

  429. 			     $this->CsAdditionalInfo->saveAll($csAddition);
    430. 

  430. 			 endforeach;
    431. 

  431. 		     }
    432. 

  432. 		     echo 'good';
    433. 

  433. 		 }
    434. 

  434. 		 else{
    435. 

  435. 		     echo 'bad';
    436. 

  436. 		 }
    437. 

  437. 	     endforeach;
    438. 

  438. 	 }
    439. 

  439.       endforeach;
    440. 

  440.     }  
    441. 

  441.     $this->render('/works/ajaxAdd2', 'ajax');
    442. 

  442.   }
    443. 

  443. 

  444.   public function removeMaterial(){
    445. 

  445.      $this->loadModel('CsMaterial');
    446. 

  446.      if($this->request->is('post')){
    447. 

  447. 	foreach($this->request->data['CsMaterial'] as $csMaterial):
    448. 

  448. 	    $this->CsMaterial->id = $csMaterial['id'];
    449. 

  449. 	    if($this->CsMaterial->delete()){
    450. 

  450. 	        echo 'good';
    451. 

  451. 	    }
    452. 

  452. 	    else{
    453. 

  453. 		echo 'bad';
    454. 

  454. 	    }
    455. 

  455. 	endforeach;
    456. 

  456.      }
    457. 

  457.     $this->render('/works/removeMaterial', 'ajax');
    458. 

  458.   }
    459. 

  459. 

  460.   public function removeAddition(){
    461. 

  461.      $this->loadModel('CsAdditionalInfo');
    462. 

  462.      if($this->request->is('post')){
    463. 

  463. 	foreach($this->request->data['CsAdditionalInfo'] as $csAddition):
    464. 

  464. 	    $this->CsAdditionalInfo->id = $csAddition['id'];
    465. 

  465. 	    if($this->CsAdditionalInfo->delete()){
    466. 

  466. 	        echo 'good';
    467. 

  467. 	    }
    468. 

  468. 	    else{
    469. 

  469. 		echo 'bad';
    470. 

  470. 	    }
    471. 

  471. 	endforeach;
    472. 

  472.      }
    473. 

  473.     $this->render('/works/removeAddition', 'ajax');
    474. 

  474.   }
    475. 

  475.   public function excelOut(){
    476. 

  476.     $this->loadModel('Complex');
    477. 

  477.     $this->loadModel('Board');
    478. 

  478.     $this->loadModel('BottomCategory');
    479. 

  479.     $this->loadModel('CsBottomCategory');
    480. 

  480.     $this->loadModel('EngineerInfo');
    481. 

  481.     $this->loadModel('ReceiverInfo');
    482. 

  482.     $this->loadModel('Life');
    483. 

  483.     $this->loadModel('UserInfo');
    484. 

  484. 

  485.     $currentTime = date("Y-m-d H:i:s");
    486. 

  486.     date_default_timezone_set('Asia/Seoul');
    487. 

  487.     
    488. 

  488.     $users = $this->UserInfo->find('list', array('fields'=> array('UserInfo.name')));
    489. 

  489. 

  490.     $conditions = array();
    491. 

  491.     $conditions['not'] = array('Complain.status' => 0);
    492. 

  492. 

  493.     if($this->request->query){
    494. 

  494.       $data = $this->request->query['data'];
    495. 

  495.       $type = $data['Search']['type'];
    496. 

  496.       $input = $data['Search']['keyword'];
    497. 

  497.       if($type == "name"){
    498. 

  498. 	$complex = array_keys($this->Complex->find('list', array('conditions' => array('Complex.name LIKE' => "%$input%"))));
    499. 

  499. 	$conditions = array('or'=> array('Board.complex_id' => $complex,
    500. 

  500. 					 'Life.complex_id' => $complex));
    501. 

  501.       }
    502. 

  502.       else if($type == "serial" || $type == "mac") {
    503. 

  503. 	$conditions = array("or" => array("Board.$type LIKE" => "%$input%",
    504. 

  504. 					  "Life.$type LIKE" => "%$input%"));
    505. 

  505.       }
    506. 

  506.       else if($type == "engineer") {
    507. 

  507.         $userinfo = array_keys($this->UserInfo->find('list', array('conditions' => array('UserInfo.name LIKE' => "%$input%"))));
    508. 

  508. 	$conditions = array("Complain.engineer_id" => $userinfo);
    509. 

  509.       }
    510. 

  510.       else {
    511. 

  511. 	$conditions = array("Complain.$type LIKE" => "%$input%");
    512. 

  512.       }
    513. 

  513.       if(!isset($data['Filter'])){
    514. 

  514. 	$data['Filter'] = array('midcategory' => 'default', 'topcategory' => 'default',  'status' => 'default',  'method' => 'default', 'region_name' => 'default', 'media' => 'default');
    515. 

  515.       }
    516. 

  516. 

  517.       foreach ( array_keys($data['Filter']) as $key) {
    518. 

  518. 	if($data['Filter'][$key] != "default"){
    519. 

  519. 	  // need a special process for foreignKeys
    520. 

  520. 	  if($key == 'method'){
    521. 

  521. 	    $conditions['or'] = array('Board.method' => $data['Filter'][$key],
    522. 

  522. 				      'Life.method' => $data['Filter'][$key]);
    523. 

  523. 	  }
    524. 

  524. 	  else if($key == 'region_name'){
    525. 

  525. 	    $ids = array_keys($this->Complex->find('list', array('conditions'=>array('region_name'=>$data['Filter']['region_name']))));
    526. 

  526. 	    $conditions['or']['Board.complex_id'] = $ids;
    527. 

  527. 	    $conditions['or']['Life.complex_id'] = $ids;
    528. 

  528. 	  }
    529. 

  529. 	  else if($key == 'topcategory' || $key == 'midcategory'){
    530. 

  530. 	    $tmp_cond = null;
    531. 

  531. 	    if($data['Filter']['topcategory'] != 'default' and $data['Filter']['midcategory'] != 'default'){
    532. 

  532. 	      $top_ids = array_keys($this->BottomCategory->TopCategory->find('list', array('conditions' => array('category' => $data['Filter']['topcategory']))));
    533. 

  533. 	      $mid_ids = array_keys($this->BottomCategory->MidCategory->find('list', array('conditions' => array('category' => $data['Filter']['midcategory']))));
    534. 

  534. 	      $tmp_cond = array('top_category_id' => $top_ids,
    535. 

  535. 				'mid_category_id' => $mid_ids);
    536. 

  536. 	    }
    537. 

  537. 	    else if($data['Filter']['topcategory'] != 'default'){
    538. 

  538. 	      $top_ids = array_keys($this->BottomCategory->TopCategory->find('list', array('conditions' => array('category' => $data['Filter']['topcategory']))));
    539. 

  539. 	      $tmp_cond = array('top_category_id' => $top_ids);
    540. 

  540. 	    }
    541. 

  541. 	    else if($data['Filter']['midcategory'] != 'default'){
    542. 

  542. 	      $mid_ids = array_keys($this->BottomCategory->MidCategory->find('list', array('conditions' => array('category' => $data['Filter']['midcategory']))));
    543. 

  543. 	      $tmp_cond = array('mid_category_id' => $mid_ids);
    544. 

  544. 	    }
    545. 

  545. 	    $bottoms = array_keys($this->BottomCategory->find('list', array('conditions'=>$tmp_cond)));
    546. 

  546. 	    $conditions['Complain.cs_bottom_category_id'] = $bottoms;
    547. 

  547. 	  }
    548. 

  548. 	  else if($key == 'media'){
    549. 

  549. 	    if($data['Filter']['media'] == '보드'){
    550. 

  550. 	      $conditions['Complain.board_id <>'] = NULL;
    551. 

  551. 	    }
    552. 

  552. 	    else if ($data['Filter']['media'] == '라이프'){
    553. 

  553. 	      $conditions['Complain.life_id <>'] = NULL;
    554. 

  554. 	    }
    555. 

  555. 	  }
    556. 

  556. 	  else if($key == 'status'){
    557. 

  557. 	    if($data['Filter']['status'] == '0'){
    558. 

  558. 	      $conditions['Complain.status'] = 0;
    559. 

  559. 	    }
    560. 

  560. 	    else if ($data['Filter']['status'] == '1'){
    561. 

  561. 	      $conditions['Complain.status'] = 1;
    562. 

  562. 	    }
    563. 

  563. 	    else if ($data['Filter']['status'] == '2'){
    564. 

  564. 	      $conditions['Complain.status'] = 2;
    565. 

  565. 	    }
    566. 

  566. 	    else if ($data['Filter']['status'] == '3'){
    567. 

  567. 	      $conditions['Complain.status'] = 3;
    568. 

  568. 	    }
    569. 

  569. 	  }
    570. 

  570. 	  else if($key == 'start_date'){
    571. 

  571. 	        if($data['Filter'][$key]){
    572. 

  572. 			$date = date('Y-m-d', strtotime($data['Filter'][$key]));
    573. 

  573. 			$conditions['Complain.end_date >='] = $date;
    574. 

  574. 		}
    575. 

  575. 	  }
    576. 

  576. 	  else if($key == 'end_date'){
    577. 

  577. 	        if($data['Filter'][$key]){
    578. 

  578. 			$date = date('Y-m-d', strtotime($data['Filter'][$key]) + 86400);
    579. 

  579. 		     	$conditions['Complain.end_date <='] = $date;
    580. 

  580. 		}
    581. 

  581. 	  }
    582. 

  582. 	}
    583. 

  583.       }
    584. 

  584.       // 검색 혹은 필터 내용 있으면 검색 처리
    585. 

  585. 

  586.     }
    587. 

  587.     $conditions['not'] = array('Complain.status' => 0);
    588. 

  588.     ///////////////////////////////
    589. 

  589.     $this->Complain->unbindModel(array('hasMany' => array('Cs'), 'belongsTo' => array('BottomCategory')));
    590. 

  590.     $this->Board->unbindModel(array('hasMany' => array('Complain')));
    591. 

  591.     $this->Life->unbindModel(array('hasMany' => array('Complain')));
    592. 

  592.     $this->EngineerInfo->unbindModel(array('hasOne' => array('User'), 'hasMany' => array('Complex', 'Complain')));
    593. 

  593.     $this->ReceiverInfo->unbindModel(array('hasOne' => array('User'), 'hasMany' => array('Complex', 'Complain')));
    594. 

  594.     $complainInfos = $this->Complain->find('all', array('recursive' => 2,'conditions' => $conditions));
    595. 

  595. 

  596.     error_reporting(E_ALL);
    597. 

  597. 

  598.     date_default_timezone_set('Europe/London');
    599. 

  599. 

  600.     /** PHPExcel */
    601. 

  601.     require_once './Classes/PHPExcel.php';
    602. 

  602. 

  603. 

  604.     // Create new PHPExcel object
    605. 

  605.     $objPHPExcel = new PHPExcel();
    606. 

  606. 

  607.     // Set properties
    608. 

  608.     $objPHPExcel->getProperties()->setCreator("CRM System")
    609. 

  609.       ->setLastModifiedBy("CRM System")
    610. 

  610.       ->setTitle("CRM System Complain report")
    611. 

  611.       ->setSubject("CRM System Complain report")
    612. 

  612.       ->setDescription("CRM System Complain report on {$currentTime}")
    613. 

  613.       ->setKeywords("Complain")
    614. 

  614.       ->setCategory("Complain result");
    615. 

  615.     
    616. 

  616.     // Add header
    617. 

  617.     $objPHPExcel->setActiveSheetIndex(0)
    618. 

  618.       ->setCellValue('A1', parent::utf8conv('등록일자'))
    619. 

  619.       ->setCellValue('B1', parent::utf8conv('대분류'))
    620. 

  620.       ->setCellValue('C1', parent::utf8conv('중분류'))
    621. 

  621.       ->setCellValue('D1', parent::utf8conv('소분류'))
    622. 

  622.       ->setCellValue('E1', parent::utf8conv('서버정보'))
    623. 

  623.       ->setCellValue('F1', parent::utf8conv('통신방식'))
    624. 

  624.       ->setCellValue('G1', parent::utf8conv('주소'))
    625. 

  625.       ->setCellValue('H1', parent::utf8conv('단지명'))
    626. 

  626.       ->setCellValue('I1', parent::utf8conv('위치정보'))
    627. 

  627.       ->setCellValue('J1', parent::utf8conv('매체'))
    628. 

  628.       ->setCellValue('K1', parent::utf8conv('시리얼'))
    629. 

  629.       ->setCellValue('L1', parent::utf8conv('제목'))
    630. 

  630.       ->setCellValue('M1', parent::utf8conv('내용'))
    631. 

  631.       ->setCellValue('N1', parent::utf8conv('요청자'))
    632. 

  632.       ->setCellValue('O1', parent::utf8conv('요청자 연락처'))
    633. 

  633.       ->setCellValue('P1', parent::utf8conv('접수자'))
    634. 

  634.       ->setCellValue('Q1', parent::utf8conv('처리자'))
    635. 

  635.       ->setCellValue('R1', parent::utf8conv('처리일자'));
    636. 

  636. 

  637. 

  638.     // Add some data
    639. 

  639.     $index = 2;
    640. 

  640.     foreach($complainInfos as $complainInfo){
    641. 

  641.       $objPHPExcel->setActiveSheetIndex(0)
    642. 

  642. 	->setCellValue("A{$index}", parent::utf8conv($complainInfo['Complain']['reg_date']))
    643. 

  643. 	->setCellValue("B{$index}", parent::utf8conv($complainInfo['CsBottomCategory']['TopCategory']['category']))
    644. 

  644. 	->setCellValue("C{$index}", parent::utf8conv($complainInfo['CsBottomCategory']['MidCategory']['category']))
    645. 

  645. 	->setCellValue("D{$index}", parent::utf8conv($complainInfo['CsBottomCategory']['category']));
    646. 

  646.       
    647. 

  647.       $serverInfo = NULL;
    648. 

  648.       $method = NULL;
    649. 

  649.       $addr = NULL;
    650. 

  650.       $complex_name = NULL;
    651. 

  651.       $location = NULL;
    652. 

  652.       $media = NULL;
    653. 

  653.       $serial = NULL;
    654. 

  654.       if(!parent::array_empty($complainInfo['Board'])){
    655. 

  655. 	$serverInfo = $complainInfo['Board']['server_name'];
    656. 

  656. 	$method = $complainInfo['Board']['method'];
    657. 

  657. 	$addr = $complainInfo['Board']['Complex']['first_addr'].' '.$complainInfo['Board']['Complex']['mid_addr'].' '.$complainInfo['Board']['Complex']['last_addr'].' '.$complainInfo['Board']['Complex']['addr'];
    658. 

  658. 	$complex_name = $complainInfo['Board']['Complex']['name'];
    659. 

  659. 	$location = $complainInfo['Board']['location'];
    660. 

  660. 	$media = '보드';
    661. 

  661. 	$serial = $complainInfo['Board']['serial'];
    662. 

  662.       }
    663. 

  663.       else if(!parent::array_empty($complainInfo['Life'])){
    664. 

  664. 	$serverInfo = $complainInfo['Life']['aed_name'];
    665. 

  665. 	$method = $complainInfo['Life']['method'];
    666. 

  666. 	$addr = $complainInfo['Life']['Complex']['first_addr'].' '.$complainInfo['Life']['Complex']['mid_addr'].' '.$complainInfo['Life']['Complex']['last_addr'].' '.$complainInfo['Life']['Complex']['addr'];
    667. 

  667. 	$complex_name = $complainInfo['Life']['Complex']['name'];
    668. 

  668. 	$location = $complainInfo['Life']['location'];
    669. 

  669. 	$media = '라이프';
    670. 

  670. 	$serial = $complainInfo['Life']['serial'];
    671. 

  671.       }
    672. 

  672.       
    673. 

  673.       $objPHPExcel->setActiveSheetIndex(0)
    674. 

  674. 	->setCellValue("E{$index}", parent::utf8conv($serverInfo))
    675. 

  675. 	->setCellValue("F{$index}", parent::utf8conv($method))
    676. 

  676. 	->setCellValue("G{$index}", parent::utf8conv($addr))
    677. 

  677. 	->setCellValue("H{$index}", parent::utf8conv($complex_name))
    678. 

  678. 	->setCellValue("I{$index}", parent::utf8conv($location))
    679. 

  679. 	->setCellValue("J{$index}", parent::utf8conv($media))
    680. 

  680. 	->setCellValue("K{$index}", parent::utf8conv($serial))
    681. 

  681. 	->setCellValue("L{$index}", parent::utf8conv($complainInfo['Complain']['title']))
    682. 

  682. 	->setCellValue("M{$index}", parent::utf8conv($complainInfo['Complain']['comment']))
    683. 

  683. 	->setCellValue("N{$index}", parent::utf8conv($complainInfo['Complain']['name']))
    684. 

  684. 	->setCellValue("O{$index}", parent::utf8conv($complainInfo['Complain']['phone']))
    685. 

  685. 	->setCellValue("P{$index}", parent::utf8conv($users[$complainInfo['Complain']['receiver_id']]))
    686. 

  686. 	->setCellValue("Q{$index}", parent::utf8conv($users[$complainInfo['Complain']['engineer_id']]))
    687. 

  687. 	->setCellValue("R{$index}", parent::utf8conv($complainInfo['Complain']['end_date']));
    688. 

  688.       $index++;
    689. 

  689.     }
    690. 

  690. 

  691.     // Rename sheet
    692. 

  692.     $objPHPExcel->getActiveSheet()->setTitle(parent::utf8conv('처리정보'));
    693. 

  693. 

  694.     // Set active sheet index to the first sheet, so Excel opens this as the first sheet
    695. 

  695.     $objPHPExcel->setActiveSheetIndex(0);
    696. 

  696. 

  697. 

  698.     // Redirect output to a client’s web browser (Excel2007)
    699. 

  699.     header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
    700. 

  700.     header('Content-Disposition: attachment;filename="처리정보'.$currentTime.'.xlsx"');
    701. 

  701.     header('Cache-Control: max-age=0');
    702. 

  702. 

  703.     $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    704. 

  704.     $objWriter->save('php://output');
    705. 

  705.     exit;
    706. 

  706. 

  707.   }
    708. 

  708. }
    709. 

  709. 

  710. ?>
    711.