SHOW:
|
|
- or go back to the newest paste.
| 1 | <?php | |
| 2 | ||
| 3 | $data_customer_scan[0] = array( | |
| 4 | "ScanID" => "12345", | |
| 5 | "customerName" => "Yudha", | |
| 6 | "salesName" => "Andri" | |
| 7 | ); | |
| 8 | $data_customer_scan[1] = array( | |
| 9 | "ScanID" => "123456", | |
| 10 | "customerName" => "Maulana", | |
| 11 | "salesName" => "Anggi" | |
| 12 | ); | |
| 13 | $data_customer_scan[2] = array( | |
| 14 | "ScanID" => "1234567", | |
| 15 | "customerName" => "Yudi", | |
| 16 | "salesName" => "Ang" | |
| 17 | ); | |
| 18 | ||
| 19 | $params['customer_name'] = "Yud"; | |
| 20 | ||
| 21 | - | if ($params['customer_name'] || $params['sales_name']) {
|
| 21 | + | //if ($params['customer_name'] || $params['sales_name']) |
| 22 | {
| |
| 23 | $search_customer = false; | |
| 24 | $search_sales = false; | |
| 25 | /* | |
| 26 | if ($params['customer_name']) {
| |
| 27 | $search_customer = true; | |
| 28 | } | |
| 29 | if ($params['sales_name']) {
| |
| 30 | $search_sales = true; | |
| 31 | } | |
| 32 | */ | |
| 33 | - | if ($search_customer) {
|
| 33 | + | |
| 34 | if (isset($params['customer_name'])) {
| |
| 35 | $customerName[] = $v['customerName']; | |
| 36 | - | if ($search_sales) {
|
| 36 | + | |
| 37 | - | $salesName[] = $v['sales']['name']; |
| 37 | + | if (isset($params['sales_name'])) {
|
| 38 | $salesName[] = $v['salesName']; //salah barusan | |
| 39 | } | |
| 40 | } | |
| 41 | /* | |
| 42 | if ($search_customer) {
| |
| 43 | // search customer by name | |
| 44 | $search_customer_name = preg_quote($params['customer_name'], '~'); | |
| 45 | $search_result_customer_name = preg_grep('~' . $search_customer_name . '~', $customerName);
| |
| 46 | } | |
| 47 | if ($search_sales) {
| |
| 48 | // search sales by name | |
| 49 | $search_sales_name = preg_quote($params['sales_name'], '~'); | |
| 50 | $search_result_sales_name = preg_grep('~' . $search_sales_name . '~', $salesName);
| |
| 51 | } | |
| 52 | */ | |
| 53 | // do search by all data | |
| 54 | - | if ($search_customer) {
|
| 54 | + | $temp=array('customer_name'=>array(),'sales_name'=>array());
|
| 55 | - | if (in_array($v['customerName'], $search_result_customer_name)) {
|
| 55 | + | |
| 56 | - | $temporary_result_cus_name[] = $v; |
| 56 | + | if (isset($params['customer_name'])) {
|
| 57 | if (in_array($params['customer_name'], array($v['customerName']) ) ) {
| |
| 58 | $temp['customer_name'][] = $v; | |
| 59 | - | if ($search_sales) {
|
| 59 | + | |
| 60 | - | if (in_array($v['sales']['name'], $search_result_sales_name)) {
|
| 60 | + | |
| 61 | - | $temporary_result_sales_name[] = $v; |
| 61 | + | |
| 62 | if (isset($params['sales_name'])) {
| |
| 63 | if (in_array($params['sales_name'], array($v['salesName']) ) ) {
| |
| 64 | $temp['sales_name'][] = $v; | |
| 65 | } | |
| 66 | } | |
| 67 | } | |
| 68 | ||
| 69 | /* | |
| 70 | // Result Customer | |
| 71 | if ($temporary_result_cus_name && $temporary_result_cus_email) {
| |
| 72 | $temp_res_customer = array_merge($temporary_result_cus_name, $temporary_result_cus_email); | |
| 73 | } else {
| |
| 74 | $temp_res_customer = !empty($temporary_result_cus_name) ? $temporary_result_cus_name : $temporary_result_cus_email; | |
| 75 | } | |
| 76 | ||
| 77 | // Result Sales | |
| 78 | if ($temporary_result_sales_name) {
| |
| 79 | $temp_res_sales = $temporary_result_sales_name; | |
| 80 | } | |
| 81 | ||
| 82 | if ($search_customer && empty($search_sales)) {
| |
| 83 | $temp_res = $temp_res_customer; | |
| 84 | } elseif (empty($search_customer) && $search_sales) {
| |
| 85 | $temp_res = $temp_res_sales; | |
| 86 | } else {
| |
| 87 | // Make operator AND MANIPULATE QUERY | |
| 88 | foreach ($temp_res_customer as $v) {
| |
| 89 | if (in_array($v['ScanID'], array_column($temp_res_sales, 'ScanID'))) {
| |
| 90 | $temp_res[] = $v; | |
| 91 | } | |
| 92 | - | var_dump($temp_res); |
| 92 | + | |
| 93 | } | |
| 94 | */ | |
| 95 | echo "<pre>"; | |
| 96 | var_dump($temp); | |
| 97 | echo "</pre>"; //ketinggalan | |
| 98 | ||
| 99 | } | |
| 100 | ||
| 101 | ?> |
