| @@ -56,7 +56,7 @@ | ||
| 56 | 56 |              $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; | 
| 57 | 57 | $qb | 
| 58 | 58 |                  ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR ' . | 
| 59 | - 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') | |
| 59 | + 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') | |
| 60 | 60 |                  ->setParameter('multi', $multi) | 
| 61 | 61 |                  ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); | 
| 62 | 62 | } | 
| @@ -52,13 +52,13 @@ discard block | ||
| 52 | 52 |                  ->setParameter('shipping_id_start', $searchData['shipping_id_start']); | 
| 53 | 53 | } | 
| 54 | 54 | // multi | 
| 55 | -        if (isset( $searchData['multi']) && Str::isNotBlank($searchData['multi'])) { | |
| 55 | +        if (isset($searchData['multi']) && Str::isNotBlank($searchData['multi'])) { | |
| 56 | 56 |              $multi = preg_match('/^\d+$/', $searchData['multi']) ? $searchData['multi'] : null; | 
| 57 | 57 | $qb | 
| 58 | -                ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR ' . | |
| 58 | +                ->andWhere('s.id = :multi OR s.name01 LIKE :likemulti OR s.name02 LIKE :likemulti OR '. | |
| 59 | 59 | 's.kana01 LIKE :likemulti OR s.kana02 LIKE :likemulti OR s.company_name LIKE :likemulti') | 
| 60 | 60 |                  ->setParameter('multi', $multi) | 
| 61 | -                ->setParameter('likemulti', '%' . $searchData['multi'] . '%'); | |
| 61 | +                ->setParameter('likemulti', '%'.$searchData['multi'].'%'); | |
| 62 | 62 | } | 
| 63 | 63 | |
| 64 | 64 | // shipping_id_end | 
| @@ -91,42 +91,42 @@ discard block | ||
| 91 | 91 |          if (isset($searchData['name']) && Str::isNotBlank($searchData['name'])) { | 
| 92 | 92 | $qb | 
| 93 | 93 |                  ->andWhere('CONCAT(s.name01, s.name02) LIKE :name') | 
| 94 | -                ->setParameter('name', '%' . $searchData['name'] . '%'); | |
| 94 | +                ->setParameter('name', '%'.$searchData['name'].'%'); | |
| 95 | 95 | } | 
| 96 | 96 | |
| 97 | 97 | // kana | 
| 98 | 98 |          if (isset($searchData['kana']) && Str::isNotBlank($searchData['kana'])) { | 
| 99 | 99 | $qb | 
| 100 | 100 |                  ->andWhere('CONCAT(s.kana01, s.kana02) LIKE :kana') | 
| 101 | -                ->setParameter('kana', '%' . $searchData['kana'] . '%'); | |
| 101 | +                ->setParameter('kana', '%'.$searchData['kana'].'%'); | |
| 102 | 102 | } | 
| 103 | 103 | |
| 104 | 104 | // order_name | 
| 105 | 105 |          if (isset($searchData['order_name']) && Str::isNotBlank($searchData['order_name'])) { | 
| 106 | 106 | $qb | 
| 107 | 107 |                  ->andWhere('CONCAT(o.name01, o.name02) LIKE :order_name') | 
| 108 | -                ->setParameter('order_name', '%' . $searchData['order_name'] . '%'); | |
| 108 | +                ->setParameter('order_name', '%'.$searchData['order_name'].'%'); | |
| 109 | 109 | } | 
| 110 | 110 | |
| 111 | 111 | // order_kana | 
| 112 | 112 |          if (isset($searchData['order_kana']) && Str::isNotBlank($searchData['order_kana'])) { | 
| 113 | 113 | $qb | 
| 114 | 114 |                  ->andWhere('CONCAT(o.kana01, s.kana02) LIKE :order_kana') | 
| 115 | -                ->setParameter('kana', '%' . $searchData['order_kana'] . '%'); | |
| 115 | +                ->setParameter('kana', '%'.$searchData['order_kana'].'%'); | |
| 116 | 116 | } | 
| 117 | 117 | |
| 118 | 118 | // order_email | 
| 119 | 119 |          if (isset($searchData['email']) && Str::isNotBlank($searchData['email'])) { | 
| 120 | 120 | $qb | 
| 121 | 121 |                  ->andWhere('o.email like :email') | 
| 122 | -                ->setParameter('email', '%' . $searchData['email'] . '%'); | |
| 122 | +                ->setParameter('email', '%'.$searchData['email'].'%'); | |
| 123 | 123 | } | 
| 124 | 124 | |
| 125 | 125 | // tel | 
| 126 | 126 |          if (isset($searchData['tel']) && Str::isNotBlank($searchData['tel'])) { | 
| 127 | 127 | $qb | 
| 128 | 128 |                  ->andWhere('CONCAT(s.tel01, s.tel02, s.tel03) LIKE :tel') | 
| 129 | -                ->setParameter('tel', '%' . $searchData['tel'] . '%'); | |
| 129 | +                ->setParameter('tel', '%'.$searchData['tel'].'%'); | |
| 130 | 130 | } | 
| 131 | 131 | |
| 132 | 132 | // payment | 
| @@ -222,7 +222,7 @@ discard block | ||
| 222 | 222 |          if (isset($searchData['buy_product_name']) && Str::isNotBlank($searchData['buy_product_name'])) { | 
| 223 | 223 | $qb | 
| 224 | 224 |                  ->andWhere('si.product_name LIKE :buy_product_name') | 
| 225 | -                ->setParameter('buy_product_name', '%' . $searchData['buy_product_name'] . '%'); | |
| 225 | +                ->setParameter('buy_product_name', '%'.$searchData['buy_product_name'].'%'); | |
| 226 | 226 | } | 
| 227 | 227 | |
| 228 | 228 | // Order By |