| @@ 427-431 (lines=5) @@ | ||
| 424 | ||
| 425 | function build_concat_dropdown($select, $table, $id_where = '', $id_value = '') { |
|
| 426 | $select_params = explode(',', $select); |
|
| 427 | if (isset($select_params[3])) { |
|
| 428 | $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' "; |
|
| 429 | } else { |
|
| 430 | $cnt_str = " $select_params[1],' (',$select_params[2],')' "; |
|
| 431 | } |
|
| 432 | $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] "; |
|
| 433 | $logintype = $this->session->userdata('logintype'); |
|
| 434 | if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') { |
|
| @@ 460-464 (lines=5) @@ | ||
| 457 | function build_concat_dropdown_refill_coupon($select, $table, $id_where = '', $id_value = '') { |
|
| 458 | $select_params = explode(',', $select); |
|
| 459 | $account_data = $this->session->userdata("accountinfo"); |
|
| 460 | if (isset($select_params[3])) { |
|
| 461 | $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' "; |
|
| 462 | } else { |
|
| 463 | $cnt_str = " $select_params[1],' (',$select_params[2],')' "; |
|
| 464 | } |
|
| 465 | $select = $select_params[0].", concat($cnt_str) as $select_params[1] "; |
|
| 466 | $logintype = $this->session->userdata('logintype'); |
|
| 467 | if ($account_data['type'] == 1 && $id_where == 'where_arr') { |
|
| @@ 486-490 (lines=5) @@ | ||
| 483 | /***********************************/ |
|
| 484 | function build_concat_select_dropdown($select, $table, $id_where = '', $id_value = '') { |
|
| 485 | $select_params = explode(',', $select); |
|
| 486 | if (isset($select_params[3])) { |
|
| 487 | $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' "; |
|
| 488 | } else { |
|
| 489 | $cnt_str = " $select_params[1],' (',$select_params[2],')' "; |
|
| 490 | } |
|
| 491 | $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] "; |
|
| 492 | $where = $id_value; |
|
| 493 | $drp_array = $this->getSelect($select, $table, $id_value); |
|
| @@ 978-982 (lines=5) @@ | ||
| 975 | function build_dropdown_invoices($select, $table, $id_where = '', $id_value = '') { |
|
| 976 | $select_params = explode(',', $select); |
|
| 977 | $select_params = explode(',', $select); |
|
| 978 | if (isset($select_params[3])) { |
|
| 979 | $cnt_str = " $select_params[1],' ',$select_params[2],' ','(',$select_params[3],')' "; |
|
| 980 | } else { |
|
| 981 | $cnt_str = " $select_params[1],' (',$select_params[2],')' "; |
|
| 982 | } |
|
| 983 | $select = $select_params[0] . ", concat($cnt_str) as $select_params[1] ,".$select_params[4] ; |
|
| 984 | $logintype = $this->session->userdata('logintype'); |
|
| 985 | if (($logintype == 1 || $logintype == 5) && $id_where == 'where_arr') { |
|
| @@ 1244-1248 (lines=5) @@ | ||
| 1241 | $where = array("id" => $id_where); |
|
| 1242 | } |
|
| 1243 | $select_params = explode(',', $select); |
|
| 1244 | if (isset($select_params[3])) { |
|
| 1245 | $cnt_str = " $select_params[0],' ',$select_params[1],' ','(',$select_params[2],')' "; |
|
| 1246 | } else { |
|
| 1247 | $cnt_str = " $select_params[0],' (',$select_params[1],')' "; |
|
| 1248 | } |
|
| 1249 | $select = "concat($cnt_str) as $select_params[0] "; |
|
| 1250 | $drp_array = $this->CI->db_model->getSelect($select, $table, $where); |
|
| 1251 | $drp_array = $drp_array->result(); |
|
| @@ 1290-1294 (lines=5) @@ | ||
| 1287 | $cnt_str = " $select_params[1],'(',$select_params[2],' ',$select_params[3],')' "; |
|
| 1288 | $select = "concat($cnt_str) as $select_params[3] "; |
|
| 1289 | $field_name = $select_params[3]; |
|
| 1290 | } elseif (isset($select_params[2])) { |
|
| 1291 | $cnt_str = " $select_params[1],' ','(',$select_params[2],')' "; |
|
| 1292 | $select = "concat($cnt_str) as $select_params[2] "; |
|
| 1293 | $field_name = $select_params[2]; |
|
| 1294 | } else { |
|
| 1295 | $select = $select_params[1]; |
|
| 1296 | $field_name = $select_params[1]; |
|
| 1297 | } |
|