Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $data_customer_scan[0] = array(
- "ScanID" => "12345",
- "customerName" => "Yudha",
- "salesName" => "Andri"
- );
- $data_customer_scan[1] = array(
- "ScanID" => "123456",
- "customerName" => "Maulana",
- "salesName" => "Anggi"
- );
- $data_customer_scan[2] = array(
- "ScanID" => "1234567",
- "customerName" => "Yudi",
- "salesName" => "Ang"
- );
- $params['customer_name'] = "Yud";
- if ($params['customer_name'] || $params['sales_name']) {
- $search_customer = false;
- $search_sales = false;
- if ($params['customer_name']) {
- $search_customer = true;
- }
- if ($params['sales_name']) {
- $search_sales = true;
- }
- foreach ($data_customer_scan as $k => $v) {
- if ($search_customer) {
- $customerName[] = $v['customerName'];
- }
- if ($search_sales) {
- $salesName[] = $v['sales']['name'];
- }
- }
- if ($search_customer) {
- // search customer by name
- $search_customer_name = preg_quote($params['customer_name'], '~');
- $search_result_customer_name = preg_grep('~' . $search_customer_name . '~', $customerName);
- }
- if ($search_sales) {
- // search sales by name
- $search_sales_name = preg_quote($params['sales_name'], '~');
- $search_result_sales_name = preg_grep('~' . $search_sales_name . '~', $salesName);
- }
- // do search by all data
- foreach ($data_customer_scan as $k => $v) {
- if ($search_customer) {
- if (in_array($v['customerName'], $search_result_customer_name)) {
- $temporary_result_cus_name[] = $v;
- }
- }
- if ($search_sales) {
- if (in_array($v['sales']['name'], $search_result_sales_name)) {
- $temporary_result_sales_name[] = $v;
- }
- }
- }
- // Result Customer
- if ($temporary_result_cus_name && $temporary_result_cus_email) {
- $temp_res_customer = array_merge($temporary_result_cus_name, $temporary_result_cus_email);
- } else {
- $temp_res_customer = !empty($temporary_result_cus_name) ? $temporary_result_cus_name : $temporary_result_cus_email;
- }
- // Result Sales
- if ($temporary_result_sales_name) {
- $temp_res_sales = $temporary_result_sales_name;
- }
- if ($search_customer && empty($search_sales)) {
- $temp_res = $temp_res_customer;
- } elseif (empty($search_customer) && $search_sales) {
- $temp_res = $temp_res_sales;
- } else {
- // Make operator AND MANIPULATE QUERY
- foreach ($temp_res_customer as $v) {
- if (in_array($v['ScanID'], array_column($temp_res_sales, 'ScanID'))) {
- $temp_res[] = $v;
- }
- }
- }
- echo "<pre>";
- var_dump($temp_res);
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement