|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TX3U' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MARIYAI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 0 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TX3U |
SON |
MARIYAI |
2023-09-01 |
20 |
0 |
10 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TIJE' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALIBELA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TIJE |
SON |
MALIBELA |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T84M' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AHMAD YANI 41' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T84M |
SON |
AHMAD YANI 41 |
2023-09-01 |
0 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TXYX' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KPR PAM' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TXYX |
SON |
KPR PAM |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TC0Z' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'NANGKA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TC0Z |
SON |
NANGKA |
2023-09-01 |
20 |
0 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TBZF' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KLAMASEN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TBZF |
SON |
KLAMASEN |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'THOD' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'YOS SUDARSO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
THOD |
SON |
YOS SUDARSO |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TP9O' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'SUNGAI KAMUNDAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '0.0' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TP9O |
SON |
SUNGAI KAMUNDAN |
2023-09-01 |
0 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
0.0 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'THM9' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'SAMRATULANGI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
THM9 |
SON |
SAMRATULANGI |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0.0 |
0.0 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TYJO' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'JENDRAL SUDIRMAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TYJO |
SON |
JENDRAL SUDIRMAN |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0.0 |
0.0 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T1KT' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'JL PRAMUKA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 0 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T1KT |
SON |
JL PRAMUKA |
2023-09-01 |
0 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
0.0 |
0.0 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TKWP' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'RAYA FRANS KAISEPO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 0 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TKWP |
SON |
RAYA FRANS KAISEPO |
2023-09-01 |
0 |
10 |
10 |
10 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TW87' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALASOM' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TW87 |
SON |
MALASOM |
2023-09-01 |
20 |
0 |
10 |
10 |
5 |
0 |
5 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T3PP' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AHMAD YANI RUKO B-D' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T3PP |
SON |
AHMAD YANI RUKO B-D |
2023-09-01 |
0 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T4ZW' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T4ZW |
SON |
BASUKI RAHMAT |
2023-09-01 |
20 |
10 |
0 |
10 |
5 |
0 |
5 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T6RD' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT KM 7 NO. 9' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T6RD |
SON |
BASUKI RAHMAT KM 7 NO. 9 |
2023-09-01 |
20 |
0 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T7TW' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BUNCIS MALAWELA' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 5 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T7TW |
SON |
BUNCIS MALAWELA |
2023-09-01 |
0 |
0 |
10 |
10 |
5 |
0 |
5 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TFIG' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KLAGETE' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TFIG |
SON |
KLAGETE |
2023-09-01 |
0 |
0 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TW4T' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'PENDIDIKAN' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TW4T |
SON |
PENDIDIKAN |
2023-09-01 |
20 |
0 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T4VV' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'AM SANGAJI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T4VV |
SON |
AM SANGAJI |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TPX8' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'KAMPUNG SALAK' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TPX8 |
SON |
KAMPUNG SALAK |
2023-09-01 |
0 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TUQG' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'TRANS AIMAS' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 0 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TUQG |
SON |
TRANS AIMAS |
2023-09-01 |
0 |
0 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TB0U' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'BASUKI RAHMAT KM 11' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TB0U |
SON |
BASUKI RAHMAT KM 11 |
2023-09-01 |
20 |
10 |
0 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'TCR7' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'MALAWEI' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 10 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 10 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
TCR7 |
SON |
MALAWEI |
2023-09-01 |
20 |
10 |
10 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |
|
|
Edit
|
Copy
|
Delete
DELETE FROM tbv_kriteria_so WHERE `tbv_kriteria_so`.`SHOP` = 'T1V9' AND `tbv_kriteria_so`.`WIL` = 'SON' AND `tbv_kriteria_so`.`DESC` = 'FRANS KAISEIPO' AND `tbv_kriteria_so`.`TGL_SO` = '2023-09-01' AND `tbv_kriteria_so`.`KONDISI_SO` = 20 AND `tbv_kriteria_so`.`LAMA_SO` = 0 AND `tbv_kriteria_so`.`JMLH_PERSONIL` = 0 AND `tbv_kriteria_so`.`JARAK_SO` = 10 AND `tbv_kriteria_so`.`TIPE_GUDANG` = 5 AND `tbv_kriteria_so`.`JMLH_RAK` = 0 AND `tbv_kriteria_so`.`STOK_TOKO` = 0 AND `tbv_kriteria_so`.`P_TOK_SB` = 0 AND `tbv_kriteria_so`.`P_TOK_RTE` = 0 AND `tbv_kriteria_so`.`P_TOK_RTD` = 0 AND `tbv_kriteria_so`.`P_TOK_BUAH` = 0 AND `tbv_kriteria_so`.`P_TOK_POINT` = 2 AND CONCAT(`tbv_kriteria_so`.`TOK_FRSH`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_POINT`) = '2.5' AND CONCAT(`tbv_kriteria_so`.`TOK_HYBRD`) = '0.0' AND CONCAT(`tbv_kriteria_so`.`TOK_MTH_STR`) = '2.5' AND `tbv_kriteria_so`.`SPD_TOKO` = 0 LIMIT 1
|
T1V9 |
SON |
FRANS KAISEIPO |
2023-09-01 |
20 |
0 |
0 |
10 |
5 |
0 |
0 |
0 |
0 |
0 |
0 |
2 |
0.0 |
2.5 |
0.0 |
2.5 |
0 |