API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 1st, 2018
132
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.40 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /**
  3. * Created by PhpStorm.
  4. * User: Arief YP
  5. * Date: 7/4/2018
  6. * Time: 4:53 PM
  7. */
  8.  
  9. class m_barber extends CI_Model
  10. {
  11. public function __construct()
  12. {
  13. parent::__construct();
  14. }
  15.  
  16. function read_latest_id(){
  17. $sql = "SELECT max(cast(BARBER_ID AS UNSIGNED)) AS BARBER_ID FROM ARFAGO_BARBER";
  18. $query = $this->db->query($sql);
  19. $result = $query -> row();
  20. if ($result->BARBER_ID==null){
  21. return '0';
  22. }
  23. else{
  24. return $result->BARBER_ID;
  25. }
  26. }
  27.  
  28. function create($param){
  29. $latestId = $this->read_latest_id();
  30. $id = $latestId + 1;
  31. $date = date('Y-m-d H:i:s');
  32. $sql = "INSERT INTO ARFAGO_BARBER(
  33. BARBER_ID,
  34. USER_NAME,
  35. BARBER_NAME,
  36. BARBER_ID_CARD,
  37. BARBER_PLACE_BIRTH,
  38. BARBER_DATE_BIRTH,
  39. BARBER_PHONE,
  40. BARBER_HOME_ADDRESS,
  41. BARBER_HOME_ZIP_CODE_ID,
  42. BARBER_WORK_ADDRESS,
  43. BARBER_WORK_ZIP_CODE_ID,
  44. BARBER_GENDER,
  45. BARBER_IMAGE_PATH,
  46. BARBER_PASSWORD,
  47. STATUS,
  48. CREATED_BY,
  49. CREATED_DATE,
  50. LAST_UPDATED_BY,
  51. LAST_UPDATED_DATE,
  52. DELETED,
  53. AVAILABILITY
  54. ) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
  55. $result = $this->db->query($sql,
  56. array(
  57. $id,
  58. $param['userName'],
  59. $param['fullName'],
  60. $param['idCard'],
  61. $param['birthPlace'],
  62. $param['birthDate'],
  63. $param['phoneNumber'],
  64. $param['addressHome'],
  65. $param['zipCodeIdHome'],
  66. $param['addressWork'],
  67. $param['zipCodeIdWork'],
  68. $param['gender'],
  69. $param['avatar'],
  70. $param['password'],
  71. ACTIVE,
  72. $param['user'],
  73. $date,
  74. $param['user'],
  75. $date,
  76. '0',
  77. 'AVAILABLE'
  78. )
  79. );
  80. if($result){
  81. return $this->create_service_allocation($id,$date,$param['user']);
  82. // return true;
  83. }else{
  84. return false;
  85. }
  86. }
  87.  
  88. function create_service_allocation($id,$date,$user){
  89. $sql = "INSERT INTO ARFAGO_SERVICE_ALLOCATION (
  90. SERVICE_ID,
  91. BARBER_ID,
  92. PRICE,
  93. BARBER_FEE,
  94. ARFAGO_FEE,
  95. BARBER_PERCENT,
  96. ARFAGO_PERCENT,
  97. CREATED_BY,
  98. CREATED_DATE,
  99. LAST_UPDATE_BY,
  100. LAST_UPDATE_DATE,
  101. STATUS)
  102. SELECT
  103. SERVICE_ID,
  104. ?,
  105. '10000',
  106. '2000',
  107. '8000',
  108. '20',
  109. '80',
  110. ?,
  111. ?,
  112. ?,
  113. ?,
  114. 'INACTIVE'
  115. FROM ARFAGO_BARBER_SERVICE WHERE STATUS='ACTIVE';";
  116. $result = $this->db->query($sql,
  117. array(
  118. $id,
  119. $user,
  120. $date,
  121. $user,
  122. $date
  123. )
  124. );
  125. if($result){
  126. return true;
  127. }else{
  128. return false;
  129. }
  130. }
  131.  
  132. function read($param){
  133. $sql = "SELECT DISTINCT
  134. BARBER.BARBER_ID,
  135. BARBER.BARBER_NAME,
  136. BARBER.BARBER_ID_CARD,
  137. BARBER.BARBER_PLACE_BIRTH,
  138. BARBER.BARBER_DATE_BIRTH,
  139. BARBER.BARBER_PHONE,
  140. BARBER.AVAILABILITY,
  141. BARBER.BARBER_HOME_ADDRESS,
  142. BARBER.BARBER_HOME_ZIP_CODE_ID,
  143. HOME_ZIP_CODE.ZIP_CODE AS BARBER_HOME_ZIP_CODE,
  144. HOME_ZIP_CODE.SUB_DISTRICT AS BARBER_HOME_SUB_DISTRICT,
  145. HOME_ZIP_CODE.DISTRICT AS BARBER_HOME_DISTRICT,
  146. HOME_ZIP_CODE.CITY AS BARBER_HOME_CITY,
  147. HOME_ZIP_CODE.PROVINCE AS BARBER_HOME_PROVINCE,
  148. HOME_ZIP_CODE.COUNTRY AS BARBER_HOME_COUNTRY,
  149. BARBER.BARBER_WORK_ADDRESS,
  150. BARBER.BARBER_WORK_ZIP_CODE_ID,
  151. WORK_ZIP_CODE.ZIP_CODE AS BARBER_WORK_ZIP_CODE,
  152. WORK_ZIP_CODE.SUB_DISTRICT AS BARBER_WORK_SUB_DISTRICT,
  153. WORK_ZIP_CODE.DISTRICT AS BARBER_WORK_DISTRICT,
  154. WORK_ZIP_CODE.CITY AS BARBER_WORK_CITY,
  155. WORK_ZIP_CODE.PROVINCE AS BARBER_WORK_PROVINCE,
  156. WORK_ZIP_CODE.COUNTRY AS BARBER_WORK_COUNTRY,
  157. BARBER.BARBER_GENDER,
  158. BARBER.BARBER_IMAGE_PATH,
  159. BARBER.STATUS,
  160. BARBER.CREATED_BY,
  161. BARBER.CREATED_DATE,
  162. BARBER.LAST_UPDATED_BY,
  163. BARBER.LAST_UPDATED_DATE,
  164. BARBER.DELETED,
  165. BARBER.AVAILABILITY
  166. FROM ARFAGO_BARBER AS BARBER
  167. LEFT JOIN ARFAGO_ZIP_CODE AS HOME_ZIP_CODE
  168. ON BARBER.BARBER_HOME_ZIP_CODE_ID = HOME_ZIP_CODE.ZIP_CODE_ID
  169. LEFT JOIN ARFAGO_ZIP_CODE AS WORK_ZIP_CODE
  170. ON BARBER.BARBER_WORK_ZIP_CODE_ID = WORK_ZIP_CODE.ZIP_CODE_ID
  171. WHERE BARBER.DELETED=0";
  172. if ($param['search']!=null){
  173. $sql.= " AND (BARBER.BARBER_NAME LIKE '%".$param['search']."%'
  174. OR BARBER.BARBER_ID_CARD LIKE '%".$param['search']."%'
  175. OR BARBER.BARBER_PHONE LIKE '%".$param['search']."%'
  176. OR BARBER.BARBER_HOME_ADDRESS LIKE '%".$param['search']."%'
  177. OR BARBER.BARBER_WORK_ADDRESS LIKE '%".$param['search']."%'
  178. OR HOME_ZIP_CODE.SUB_DISTRICT LIKE '%".$param['search']."%'
  179. OR WORK_ZIP_CODE.SUB_DISTRICT LIKE '%".$param['search']."%'
  180. OR HOME_ZIP_CODE.DISTRICT LIKE '%".$param['search']."%'
  181. OR WORK_ZIP_CODE.DISTRICT LIKE '%".$param['search']."%'
  182. OR HOME_ZIP_CODE.CITY LIKE '%".$param['search']."%'
  183. OR WORK_ZIP_CODE.CITY LIKE '%".$param['search']."%'
  184. OR HOME_ZIP_CODE.PROVINCE LIKE '%".$param['search']."%'
  185. OR WORK_ZIP_CODE.PROVINCE LIKE '%".$param['search']."%'
  186. OR HOME_ZIP_CODE.COUNTRY LIKE '%".$param['search']."%'
  187. OR WORK_ZIP_CODE.COUNTRY LIKE '%".$param['search']."%'
  188. )";
  189. }
  190. if ($param['barberId']!=null){
  191. $sql.= " AND BARBER.BARBER_ID=".$param['barberId'];
  192. }
  193. if ($param['length']!=null||$param['start']!=null){
  194. $sql .= " ORDER BY CREATED_DATE DESC LIMIT ".$param['length']." OFFSET ".$param['start'];
  195. }
  196. $query = $this->db->query($sql);
  197. $result = $query -> result_array();
  198. return $result;
  199. }
  200.  
  201. function read_mobile($param){
  202. $sql = "SELECT DISTINCT
  203. BARBER.BARBER_ID,
  204. BARBER.BARBER_NAME,
  205. BARBER.BARBER_ID_CARD,
  206. BARBER.BARBER_PLACE_BIRTH,
  207. BARBER.BARBER_DATE_BIRTH,
  208. BARBER.AVAILABILITY,
  209. BARBER.BARBER_PHONE,
  210. BARBER.BARBER_HOME_ADDRESS,
  211. BARBER.BARBER_HOME_ZIP_CODE_ID,
  212. HOME_ZIP_CODE.ZIP_CODE AS BARBER_HOME_ZIP_CODE,
  213. HOME_ZIP_CODE.SUB_DISTRICT AS BARBER_HOME_SUB_DISTRICT,
  214. HOME_ZIP_CODE.DISTRICT AS BARBER_HOME_DISTRICT,
  215. HOME_ZIP_CODE.CITY AS BARBER_HOME_CITY,
  216. HOME_ZIP_CODE.PROVINCE AS BARBER_HOME_PROVINCE,
  217. HOME_ZIP_CODE.COUNTRY AS BARBER_HOME_COUNTRY,
  218. BARBER.BARBER_WORK_ADDRESS,
  219. BARBER.BARBER_WORK_ZIP_CODE_ID,
  220. WORK_ZIP_CODE.ZIP_CODE AS BARBER_WORK_ZIP_CODE,
  221. WORK_ZIP_CODE.SUB_DISTRICT AS BARBER_WORK_SUB_DISTRICT,
  222. WORK_ZIP_CODE.DISTRICT AS BARBER_WORK_DISTRICT,
  223. WORK_ZIP_CODE.CITY AS BARBER_WORK_CITY,
  224. WORK_ZIP_CODE.PROVINCE AS BARBER_WORK_PROVINCE,
  225. WORK_ZIP_CODE.COUNTRY AS BARBER_WORK_COUNTRY,
  226. BARBER.BARBER_GENDER,
  227. BARBER.BARBER_IMAGE_PATH,
  228. BARBER.STATUS,
  229. BARBER.CREATED_BY,
  230. BARBER.CREATED_DATE,
  231. BARBER.LAST_UPDATED_BY,
  232. BARBER.LAST_UPDATED_DATE,
  233. BARBER.DELETED,
  234. BARBER.AVAILABILITY
  235. FROM ARFAGO_BARBER AS BARBER
  236. LEFT JOIN ARFAGO_ZIP_CODE AS HOME_ZIP_CODE
  237. ON BARBER.BARBER_HOME_ZIP_CODE_ID = HOME_ZIP_CODE.ZIP_CODE_ID
  238. LEFT JOIN ARFAGO_ZIP_CODE AS WORK_ZIP_CODE
  239. ON BARBER.BARBER_WORK_ZIP_CODE_ID = WORK_ZIP_CODE.ZIP_CODE_ID
  240. WHERE BARBER.STATUS='ACTIVE'
  241. ";
  242. if ($param['search']!=null){
  243. $sql.= " AND (BARBER.BARBER_WORK_ADDRESS LIKE '%".$param['search']."%'
  244. OR WORK_ZIP_CODE.ZIP_CODE LIKE '%".$param['search']."%'
  245. OR WORK_ZIP_CODE.SUB_DISTRICT LIKE '%".$param['search']."%'
  246. OR WORK_ZIP_CODE.DISTRICT LIKE '%".$param['search']."%'
  247. OR WORK_ZIP_CODE.CITY LIKE '%".$param['search']."%'
  248. OR WORK_ZIP_CODE.PROVINCE LIKE '%".$param['search']."%'
  249. OR WORK_ZIP_CODE.COUNTRY LIKE '%".$param['search']."%'
  250. )";
  251. }
  252. $query = $this->db->query($sql);
  253. $result = $query -> result_array();
  254. return $result;
  255. }
  256.  
  257. function update($param) {
  258. $date = date('Y-m-d H:i:s');
  259. $sql = "UPDATE ARFAGO_BARBER SET
  260. BARBER_NAME=?,
  261. BARBER_ID_CARD=?,
  262. BARBER_PLACE_BIRTH=?,
  263. BARBER_DATE_BIRTH=?,
  264. BARBER_PHONE=?,
  265. BARBER_HOME_ADDRESS=?,
  266. BARBER_WORK_ADDRESS=?,
  267. BARBER_HOME_ZIP_CODE_ID=?,
  268. BARBER_WORK_ZIP_CODE_ID=?,
  269. BARBER_GENDER=?,
  270. LAST_UPDATED_BY=?,
  271. LAST_UPDATED_DATE=?";
  272. if ($param['avatar']!=null){
  273. $sql.= ",BARBER_IMAGE_PATH=?";
  274. }
  275. $sql .= " WHERE BARBER_ID=?";
  276. $data = array(
  277. $param['fullName'],
  278. $param['idCard'],
  279. $param['birthPlace'],
  280. $param['birthDate'],
  281. $param['phoneNumber'],
  282. $param['addressHome'],
  283. $param['addressWork'],
  284. $param['zipCodeIdHome'],
  285. $param['zipCodeIdWork'],
  286. $param['gender'],
  287. $param['user'],
  288. $date
  289. );
  290. if ($param['avatar']!=null){
  291. array_push($data,$param['avatar']);
  292. }
  293. array_push($data,$param['id']);
  294. $query = $this->db->query($sql,$data);
  295. if($query){
  296. return true;
  297. }else{
  298. return false;
  299. }
  300. }
  301.  
  302. function get_mobile($param){
  303. $sql ="SELECT
  304. BARBER_ID,
  305. USER_NAME,
  306. BARBER_GENDER AS GENDER_CODE,
  307. CASE
  308. WHEN BARBER_GENDER ='M' THEN '".lang("male")."'
  309. ELSE '".lang("female")."'
  310. END AS GENDER_NAME,
  311. BARBER_NAME,
  312. BARBER_IMAGE_PATH,
  313. BARBER_PLACE_BIRTH,
  314. BARBER_DATE_BIRTH,
  315. BARBER_PHONE
  316. FROM ARFAGO_BARBER WHERE DELETED =0 ";
  317. if(!empty($param["barberId"])){
  318. $sql.= " AND BARBER_ID='".$param["barberId"]."'";
  319. }
  320. if(!empty($param["gender"])){
  321. $sql.= " AND BARBER_GENDER ='".$param["gender"]."'";
  322. }
  323. if(!empty($param["fullName"])){
  324. $sql.= " AND BARBER_NAME like '%".$param["fullName"]."%'";
  325. }
  326. if(!empty($param["userName"])){
  327. $sql.= " AND UPPER(USER_NAME)=UPPER('".$param["userName"]."')";
  328. }
  329. $query = $this->db->query($sql);
  330. $result = $query -> row();
  331. return $result;
  332. }
  333.  
  334. function update_mobile($param) {
  335. $date = date('Y-m-d H:i:s');
  336. $sql = "UPDATE ARFAGO_BARBER SET
  337. BARBER_NAME = ?,
  338. BARBER_PLACE_BIRTH = ?,
  339. BARBER_DATE_BIRTH = ?,
  340. BARBER_PHONE = ?,
  341. BARBER_GENDER = ?,
  342. LAST_UPDATED_BY = ?,
  343. LAST_UPDATED_DATE = ?";
  344. if ($param['avatar']!=null){
  345. $sql.= ", BARBER_IMAGE_PATH = ?";
  346. }
  347. $sql .= " WHERE BARBER_ID = ?";
  348. $data = array(
  349. $param['fullName'],
  350. $param['birthPlace'],
  351. $param['birthDate'],
  352. $param['phoneNumber'],
  353. $param['gender'],
  354. $param['user'],
  355. $date
  356. );
  357. if ($param['avatar']!=null){
  358. array_push($data,$param['avatar']);
  359. }
  360. array_push($data,$param['id']);
  361. $query = $this->db->query($sql,$data);
  362. if($query){
  363. return true;
  364. }else{
  365. return false;
  366. }
  367. }
  368.  
  369. // function delete($param) {
  370. // $sql = "UPDATE ARFAGO_BARBER SET STATUS='DEACTIVE' WHERE BARBER_ID='$param'";
  371. // $result = $this->db->query($sql);
  372. // if($result){
  373. // return true;
  374. // }else{
  375. // return false;
  376. // }
  377. // }
  378.  
  379. function update_status($param) {
  380. $sql = "UPDATE ARFAGO_BARBER SET STATUS=? WHERE BARBER_ID=?";
  381. if ($param['status']=='ACTIVE'){
  382. $status = 'INACTIVE';
  383. }
  384. else{
  385. $status = 'ACTIVE';
  386. }
  387. $result = $this->db->query($sql,
  388. array(
  389. $status,
  390. $param['barberId']
  391. ));
  392. if($result){
  393. return true;
  394. }else{
  395. return false;
  396. }
  397. }
  398.  
  399. function count($param) {
  400. $sql = "SELECT count(BARBER.BARBER_ID) as total
  401. FROM ARFAGO_BARBER AS BARBER
  402. LEFT JOIN ARFAGO_ZIP_CODE AS HOME_ZIP_CODE
  403. ON BARBER.BARBER_HOME_ZIP_CODE_ID = HOME_ZIP_CODE.ZIP_CODE_ID
  404. LEFT JOIN ARFAGO_ZIP_CODE AS WORK_ZIP_CODE
  405. ON BARBER.BARBER_WORK_ZIP_CODE_ID = WORK_ZIP_CODE.ZIP_CODE_ID
  406. WHERE BARBER.DELETED=0
  407. ";
  408. if ($param!=null){
  409. $sql.= " AND (BARBER.BARBER_NAME LIKE '%".$param."%'
  410. OR BARBER.BARBER_ID_CARD LIKE '%".$param."%'
  411. OR BARBER.BARBER_PHONE LIKE '%".$param."%'
  412. OR BARBER.BARBER_HOME_ADDRESS LIKE '%".$param."%'
  413. OR BARBER.BARBER_WORK_ADDRESS LIKE '%".$param."%'
  414. OR HOME_ZIP_CODE.SUB_DISTRICT LIKE '%".$param."%'
  415. OR WORK_ZIP_CODE.SUB_DISTRICT LIKE '%".$param."%'
  416. OR HOME_ZIP_CODE.DISTRICT LIKE '%".$param."%'
  417. OR WORK_ZIP_CODE.DISTRICT LIKE '%".$param."%'
  418. OR HOME_ZIP_CODE.CITY LIKE '%".$param."%'
  419. OR WORK_ZIP_CODE.CITY LIKE '%".$param."%'
  420. OR HOME_ZIP_CODE.PROVINCE LIKE '%".$param."%'
  421. OR WORK_ZIP_CODE.PROVINCE LIKE '%".$param."%'
  422. OR HOME_ZIP_CODE.COUNTRY LIKE '%".$param."%'
  423. OR WORK_ZIP_CODE.COUNTRY LIKE '%".$param."%'
  424. )";
  425. }
  426. // $sql.=" GROUP BY BARBER.STATUS";
  427. $query = $this->db->query($sql);
  428. $result = $query -> result();
  429. return (int)$result[0]->total;
  430. }
  431.  
  432. //barber
  433. function get($param){
  434. $sql = "SELECT
  435. BARBER.BARBER_ID,
  436. BARBER.USER_NAME,
  437. BARBER.BARBER_NAME,
  438. BARBER.BARBER_ID_CARD,
  439. BARBER.BARBER_PLACE_BIRTH,
  440. BARBER.BARBER_DATE_BIRTH,
  441. BARBER.BARBER_PHONE,
  442. BARBER.BARBER_HOME_ADDRESS,
  443. BARBER.BARBER_HOME_ZIP_CODE_ID,
  444. BARBER.AVAILABILITY,
  445. HOME_ZIP_CODE.ZIP_CODE AS BARBER_HOME_ZIP_CODE,
  446. HOME_ZIP_CODE.SUB_DISTRICT AS BARBER_HOME_SUB_DISTRICT,
  447. HOME_ZIP_CODE.DISTRICT AS BARBER_HOME_DISTRICT,
  448. HOME_ZIP_CODE.CITY AS BARBER_HOME_CITY,
  449. HOME_ZIP_CODE.PROVINCE AS BARBER_HOME_PROVINCE,
  450. HOME_ZIP_CODE.COUNTRY AS BARBER_HOME_COUNTRY,
  451. BARBER.BARBER_WORK_ADDRESS,
  452. BARBER.BARBER_WORK_ZIP_CODE_ID,
  453. WORK_ZIP_CODE.ZIP_CODE AS BARBER_WORK_ZIP_CODE,
  454. WORK_ZIP_CODE.SUB_DISTRICT AS BARBER_WORK_SUB_DISTRICT,
  455. WORK_ZIP_CODE.DISTRICT AS BARBER_WORK_DISTRICT,
  456. WORK_ZIP_CODE.CITY AS BARBER_WORK_CITY,
  457. WORK_ZIP_CODE.PROVINCE AS BARBER_WORK_PROVINCE,
  458. WORK_ZIP_CODE.COUNTRY AS BARBER_WORK_COUNTRY,
  459. BARBER.BARBER_GENDER,
  460. BARBER.BARBER_IMAGE_PATH,
  461. BARBER.BARBER_PASSWORD,
  462. BARBER.STATUS,
  463. BARBER.CREATED_DATE,
  464. BARBER.CREATED_BY,
  465. BARBER.LAST_UPDATED_BY,
  466. BARBER.LAST_UPDATED_DATE,
  467. BARBER.DELETED
  468. FROM ARFAGO_BARBER AS BARBER
  469. LEFT JOIN ARFAGO_ZIP_CODE AS HOME_ZIP_CODE
  470. ON BARBER.BARBER_HOME_ZIP_CODE_ID = HOME_ZIP_CODE.ZIP_CODE_ID
  471. LEFT JOIN ARFAGO_ZIP_CODE AS WORK_ZIP_CODE
  472. ON BARBER.BARBER_WORK_ZIP_CODE_ID = WORK_ZIP_CODE.ZIP_CODE_ID
  473. WHERE BARBER.DELETED=0";
  474. if($param['userName'] !=null){
  475. $sql.=" AND BARBER.USER_NAME = '".$param['userName']."'";
  476. }else if($param['barberId'] !=null){
  477. $sql.=" AND BARBER.BARBER_ID = '".$param['barberId']."'";
  478. }
  479. $query = $this->db->query($sql);
  480. $result = $query -> row();
  481. return $result;
  482. }
  483. function updatePassword($param){
  484. $sql = "UPDATE ARFAGO_BARBER SET
  485. BARBER_PASSWORD = ?,
  486. LAST_UPDATED_BY=?,
  487. LAST_UPDATED_DATE=?
  488. WHERE BARBER_ID=?
  489. ";
  490. $query = $this->db->query($sql,$param);
  491. if($query){
  492. return true;
  493. }else{
  494. return false;
  495. }
  496. }
  497. function updateStatusAvailability($param){
  498. $sql = "UPDATE ARFAGO_BARBER SET
  499. AVAILABILITY= ? ,
  500. LAST_UPDATED_BY=? ,
  501. LAST_UPDATED_DATE=?
  502. WHERE BARBER_ID=?";
  503. $query = $this->db->query($sql,$param);
  504. if($query){
  505. return true;
  506. }else{
  507. return false;
  508. }
  509. }
  510.  
  511. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!