@@ -37,7 +37,7 @@ |
||
| 37 | 37 | /** |
| 38 | 38 | * |
| 39 | 39 | * @param array $searchData |
| 40 | - * @return QueryBuilder |
|
| 40 | + * @return \Doctrine\ORM\QueryBuilder |
|
| 41 | 41 | */ |
| 42 | 42 | public function getQueryBuilderBySearchDataForAdmin($searchData) |
| 43 | 43 | { |
@@ -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 |