private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
if (isset($filters['D04_DEN_NO']) && $filters['D04_DEN_NO']) {
$query->andwhere('D04_DEN_NO=:den_no', [':den_no' => $filters['D04_DEN_NO']]);
}
if (isset($filters['D04_SAGYO_NO']) && $filters['D04_SAGYO_NO']) {
$query->andwhere('D04_SAGYO_NO=:sagyo_no', [':sagyo_no' => $filters['D04_SAGYO_NO']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
if (isset($filters['D02_CUST_NO']) && $filters['D02_CUST_NO']) {
$query->andwhere('D02_CUST_NO =:cust_no', [':cust_no' => $filters['D02_CUST_NO']]);
}
if (isset($filters['D02_CAR_NO']) && $filters['D02_CAR_NO']) {
$query->andwhere('D02_CAR_NO =:car_no', [':car_no' => $filters['D02_CAR_NO']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
//$query->where('status=:status', [':status' => $status]);
if (isset($filters['D01_KAIIN_CD']) && $filters['D01_KAIIN_CD']) {
$query->andwhere('D01_KAIIN_CD = ' . $filters['D01_KAIIN_CD']);
}
if (isset($filters['D01_CUST_NO']) && $filters['D01_CUST_NO']) {
$query->andwhere('D01_CUST_NO = ' . $filters['D01_CUST_NO']);
}
if (isset($filters['D01_KAKE_CARD_NO']) && $filters['D01_KAKE_CARD_NO']) {
$query->where(['D01_KAKE_CARD_NO' => $filters['D01_KAKE_CARD_NO']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
if (count($filters)) {
foreach ($filters as $field => $val) {
if ($field != 'offset' && $field != 'limit') {
$query->andwhere($field . ' = ' . $val);
}
}
}
//$query->where('status=:status', [':status' => $status]);
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
/**
* Пулечение всех юо.лиц в регионе плательщиков взносов
* @param null $regional_id
* @param $region_id
* @return array
*/
public static function getUr_l_in_region($regional_id, $region_id)
{
$regional_id = (int) $regional_id;
$region_id = (int) $region_id;
$db = new Query();
$db->from(Ur::tableName());
$db->select(['ur_l.name', 'ur_l.id']);
$db->innerJoin('region_ur_l', "region_ur_l.id_ur = ur_l.id");
$db->Where(['=', 'region_ur_l.id_reg', $region_id]);
$db->andWhere(['=', 'ur_l.plat', '1']);
$db->andwhere(['=', 'ur_l.regional_id', $regional_id]);
$db->orderBy('ur_l.name ASC');
$return = $db->all();
return $return;
}
private function getWhereSearch($filters)
{
$query = new Query();
$query->select(["SDP_TD03_DENPYO.*, TO_CHAR(D03_UPD_DATE, 'YYYY/mm/DD') as CHAR_D03_UPD_DATE,\n SDP_TD01_CUSTOMER.D01_CUST_NAMEN, SDP_TD01_CUSTOMER.D01_CUST_NAMEK, SDP_TD01_CUSTOMER.D01_NOTE"])->from(static::tableName())->leftJoin('SDP_TD01_CUSTOMER', 'SDP_TD03_DENPYO.D03_CUST_NO = SDP_TD01_CUSTOMER.D01_CUST_NO')->orderBy('D03_DEN_NO');
if (isset($filters['status']) && $filters['status'] != '') {
if ($filters['status'] == 1) {
$query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 0]);
$query->andWhere(['>', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', date('Ymd')]);
}
if ($filters['status'] == 2) {
$query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 1]);
}
if ($filters['status'] == 0) {
$query->andwhere('SDP_TD03_DENPYO.D03_STATUS=:status', [':status' => 0]);
$query->andWhere(['<=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', date('Ymd')]);
}
}
if (isset($filters['car']) && $filters['car']) {
$query->andwhere(['like', 'SDP_TD03_DENPYO.D03_CAR_NO', $filters['car']]);
}
if (isset($filters['job']) && $filters['job'] != '') {
$denpyo_sagyo = new Sdptd04denpyosagyo();
$data = $denpyo_sagyo->getData(['D04_SAGYO_NO' => $filters['job']]);
$arr_den_no = [-1];
foreach ($data as $k => $v) {
$arr_den_no[] = $v['D04_DEN_NO'];
}
$query->andwhere(['in', 'SDP_TD03_DENPYO.D03_DEN_NO', $arr_den_no]);
}
if (isset($filters['start_time']) && $filters['start_time']) {
$query->andwhere(['>=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', $filters['start_time']]);
}
if (isset($filters['end_time']) && $filters['end_time']) {
$query->andwhere(['<=', 'SDP_TD03_DENPYO.D03_SEKOU_YMD', $filters['end_time']]);
}
if (isset($filters['detail_no'])) {
$query->andwhere('SDP_TD03_DENPYO.D03_DEN_NO=:den_no', [':den_no' => $filters['detail_no']]);
}
if (isset($filters['m50_ss_cd'])) {
$query->andwhere('SDP_TD03_DENPYO.D03_SS_CD =:m50_ss_cd', [':m50_ss_cd' => $filters['m50_ss_cd']]);
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
/**
* @param array $filters
* @param string $select
* @return Query
*/
private function getWhere($filters = [], $select = '*')
{
$query = new Query();
$query->select($select)->from(static::tableName());
if (isset($filters['M05_COM_CD_IN']) && $filters['M05_COM_CD_IN'] != '') {
$query->andwhere(['IN', 'M05_COM_CD', $filters['M05_COM_CD_IN']]);
}
if (isset($filters['M05_COM_CD']) && $filters['M05_COM_CD'] != '') {
$query->andwhere(['like', 'M05_COM_CD', $filters['M05_COM_CD']]);
}
if (isset($filters['M05_COM_NAMEN']) && $filters['M05_COM_NAMEN'] != '') {
$query->andwhere(['like', 'M05_COM_NAMEN', $filters['M05_COM_NAMEN']]);
}
if (isset($filters['M05_NST_CD']) && $filters['M05_NST_CD'] != '') {
$query->andwhere(['like', 'M05_NST_CD', $filters['M05_NST_CD']]);
}
if (isset($filters['in']) && count($filters['in'])) {
$query->andwhere(['IN', 'M05_KIND_DM_NO', $filters['in']]);
}
if (isset($filters['not_in']) && count($filters['not_in'])) {
$query->andwhere('M05_KIND_DM_NO NOT IN (' . implode(',', $filters['not_in']) . ') OR M05_KIND_DM_NO IS NULL');
}
if (isset($filters['offset']) && $filters['offset']) {
$query->offset($filters['offset']);
}
if (isset($filters['limit']) && $filters['limit']) {
$query->limit($filters['limit']);
}
return $query;
}
