|
Ключ
Эта строка удалена.
Это слово было удалено. Это слово было добавлено.
Эта строка добавлена.
|
Изменения (6)
просмотр истории страницы... |
'"1";"' || coalesce(case |
when fo.operator_name = 'CITY_PAY' then '1' when fo.operator_name = 'EXPRESS_VOLGA' then '2' when fo.operator_name = 'ForwardMobile' then '3' when fo.operator_name = 'JCC' then '4' when fo.operator_name = 'Kassa24' then '5' when fo.operator_name = 'KAZKOMBANK' then '6' when fo.operator_name = 'Krasplat' then '7' when fo.operator_name = 'MINBANK' then '8' when fo.operator_name = 'MKB_OSMP' then '9' when fo.operator_name = 'OSMP_Amigo' then '10' when fo.operator_name = 'OSMP_CHECK' then '11' when fo.operator_name = 'OSMP_DELTAPAY' then '12' when fo.operator_name = 'OSMP_EXPRESS_OPLATA' then '13' when fo.operator_name = 'OSMP_INTERPAY' then '14' when fo.operator_name = 'OSMP_MOROZOV' then '15' when fo.operator_name = 'OSMP_QIWI' then '16' when fo.operator_name = 'OSMP_SBRF' then '17' when fo.operator_name = 'OSMP_SIPAY' then '18' when fo.operator_name = 'PAYANYWAY' then '19' when fo.operator_name = 'Payfon_phone' then '20' when fo.operator_name = 'PAYMASTER' then '21' when fo.operator_name = 'PAYNET_UZ' then '22' when fo.operator_name = 'QIWI_OSMP' then '23' when fo.operator_name = 'Qiwiwallet' then '24' when fo.operator_name = 'SBERBANK_ACQ' then '25' when fo.operator_name = 'SBRF_BS' then '26' when fo.operator_name = 'TelePay' then '27' when fo.operator_name = 'UBRIR' then '28' when fo.operator_name = 'UCS_ACQ' then '29' when fo.operator_name = 'Uniteller' then '30' when fo.operator_name = 'UnitellerAutopay' then '31' when fo.operator_name = 'XPLAT' then '32' when fo.operator_name is null then '33' |
when fo.operator_name = 'CITY_PAY' then '1' when fo.operator_name = 'EXPRESS_VOLGA' then '2' when fo.operator_name = 'ForwardMobile' then '3' when fo.operator_name = 'JCC' then '4' when fo.operator_name = 'Kassa24' then '5' when fo.operator_name = 'KAZKOMBANK' then '6' when fo.operator_name = 'Krasplat' then '7' when fo.operator_name = 'MINBANK' then '8' when fo.operator_name = 'MKB_OSMP' then '9' when fo.operator_name = 'OSMP_Amigo' then '10' when fo.operator_name = 'OSMP_CHECK' then '11' when fo.operator_name = 'OSMP_DELTAPAY' then '12' when fo.operator_name = 'OSMP_EXPRESS_OPLATA' then '13' when fo.operator_name = 'OSMP_INTERPAY' then '14' when fo.operator_name = 'OSMP_MOROZOV' then '15' when fo.operator_name = 'OSMP_QIWI' then '16' when fo.operator_name = 'OSMP_SBRF' then '17' when fo.operator_name = 'OSMP_SIPAY' then '18' when fo.operator_name = 'PAYANYWAY' then '19' when fo.operator_name = 'Payfon_phone' then '20' when fo.operator_name = 'PAYKEEPER' then '21' when fo.operator_name = 'PAYMASTER' then '22' when fo.operator_name = 'PAYNET_UZ' then '23' when fo.operator_name = 'PayPal' then '24' when fo.operator_name = 'QIWI_OSMP' then '25' when fo.operator_name = 'QIWI(REST)' then '26' when fo.operator_name = 'Qiwiwallet' then '27' when fo.operator_name = 'RAPIDA' then '28' when fo.operator_name = 'SBERBANK_ACQ' then '29' when fo.operator_name = 'SBRF_BS' then '30' when fo.operator_name = 'SBRF_KIBERPLAT' then '31' when fo.operator_name = 'TelePay' then '32' when fo.operator_name = 'TINKOFF' then '33' when fo.operator_name = 'UBRIR' then '34' when fo.operator_name = 'UCS_ACQ' then '35' when fo.operator_name = 'Uniteller' then '36' when fo.operator_name = 'UnitellerAutopay' then '37' when fo.operator_name = 'XPLAT' then '38' when fo.operator_name is null then '39' |
else '-' end,'-') |
... |
'"1";"' || coalesce(case |
when fo.operator_name = 'CITY_PAY' then '1' when fo.operator_name = 'EXPRESS_VOLGA' then '2' when fo.operator_name = 'ForwardMobile' then '3' when fo.operator_name = 'JCC' then '4' when fo.operator_name = 'Kassa24' then '5' when fo.operator_name = 'KAZKOMBANK' then '6' when fo.operator_name = 'Krasplat' then '7' when fo.operator_name = 'MINBANK' then '8' when fo.operator_name = 'MKB_OSMP' then '9' when fo.operator_name = 'OSMP_Amigo' then '10' when fo.operator_name = 'OSMP_CHECK' then '11' when fo.operator_name = 'OSMP_DELTAPAY' then '12' when fo.operator_name = 'OSMP_EXPRESS_OPLATA' then '13' when fo.operator_name = 'OSMP_INTERPAY' then '14' when fo.operator_name = 'OSMP_MOROZOV' then '15' when fo.operator_name = 'OSMP_QIWI' then '16' when fo.operator_name = 'OSMP_SBRF' then '17' when fo.operator_name = 'OSMP_SIPAY' then '18' when fo.operator_name = 'PAYANYWAY' then '19' when fo.operator_name = 'Payfon_phone' then '20' when fo.operator_name = 'PAYMASTER' then '21' when fo.operator_name = 'PAYNET_UZ' then '22' when fo.operator_name = 'QIWI_OSMP' then '23' when fo.operator_name = 'Qiwiwallet' then '24' when fo.operator_name = 'SBERBANK_ACQ' then '25' when fo.operator_name = 'SBRF_BS' then '26' when fo.operator_name = 'TelePay' then '27' when fo.operator_name = 'UBRIR' then '28' when fo.operator_name = 'UCS_ACQ' then '29' when fo.operator_name = 'Uniteller' then '30' when fo.operator_name = 'UnitellerAutopay' then '31' when fo.operator_name = 'XPLAT' then '32' when fo.operator_name is null then '33' |
when fo.operator_name = 'CITY_PAY' then '1' when fo.operator_name = 'EXPRESS_VOLGA' then '2' when fo.operator_name = 'ForwardMobile' then '3' when fo.operator_name = 'JCC' then '4' when fo.operator_name = 'Kassa24' then '5' when fo.operator_name = 'KAZKOMBANK' then '6' when fo.operator_name = 'Krasplat' then '7' when fo.operator_name = 'MINBANK' then '8' when fo.operator_name = 'MKB_OSMP' then '9' when fo.operator_name = 'OSMP_Amigo' then '10' when fo.operator_name = 'OSMP_CHECK' then '11' when fo.operator_name = 'OSMP_DELTAPAY' then '12' when fo.operator_name = 'OSMP_EXPRESS_OPLATA' then '13' when fo.operator_name = 'OSMP_INTERPAY' then '14' when fo.operator_name = 'OSMP_MOROZOV' then '15' when fo.operator_name = 'OSMP_QIWI' then '16' when fo.operator_name = 'OSMP_SBRF' then '17' when fo.operator_name = 'OSMP_SIPAY' then '18' when fo.operator_name = 'PAYANYWAY' then '19' when fo.operator_name = 'Payfon_phone' then '20' when fo.operator_name = 'PAYKEEPER' then '21' when fo.operator_name = 'PAYMASTER' then '22' when fo.operator_name = 'PAYNET_UZ' then '23' when fo.operator_name = 'PayPal' then '24' when fo.operator_name = 'QIWI_OSMP' then '25' when fo.operator_name = 'QIWI(REST)' then '26' when fo.operator_name = 'Qiwiwallet' then '27' when fo.operator_name = 'RAPIDA' then '28' when fo.operator_name = 'SBERBANK_ACQ' then '29' when fo.operator_name = 'SBRF_BS' then '30' when fo.operator_name = 'SBRF_KIBERPLAT' then '31' when fo.operator_name = 'TelePay' then '32' when fo.operator_name = 'TINKOFF' then '33' when fo.operator_name = 'UBRIR' then '34' when fo.operator_name = 'UCS_ACQ' then '35' when fo.operator_name = 'Uniteller' then '36' when fo.operator_name = 'UnitellerAutopay' then '37' when fo.operator_name = 'XPLAT' then '38' when fo.operator_name is null then '39' |
else '-' end,'-') |
... |
При необходимости, список можно сократить в соответствии с используемыми платежными системами, но рекомендуется данный список выгрузить целиком. {code} |
"1";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"CITY_PAY" "2";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"EXPRESS_VOLGA" "3";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"ForwardMobile" "4";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"JCC" "5";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Kassa24" "6";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"KAZKOMBANK" "7";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Krasplat" "8";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"MINBANK" "9";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"MKB_OSMP" "10";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_Amigo" "11";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_CHECK" "12";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_DELTAPAY" "13";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_EXPRESS_OPLATA" "14";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_INTERPAY" "15";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_MOROZOV" "16";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_QIWI" "17";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_SBRF" "18";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"OSMP_SIPAY" "19";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"PAYANYWAY" "20";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Payfon_phone" "21";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"PAYMASTER" "22";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"PAYNET_UZ" "23";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"QIWI_OSMP" "24";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Qiwiwallet" "25";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"SBERBANK_ACQ" "26";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"SBRF_BS" "27";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"TelePay" "28";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"UBRIR" "29";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"UCS_ACQ" "30";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Uniteller" "31";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"UnitellerAutopay" "32";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"XPLAT" "33";"01.01.2017 00:00:00";""01.01.2017 00:00:00";"Поступление наличных" |
"1";"01.01.2017 00:00:00";"";"CITY_PAY" "2";"01.01.2017 00:00:00";"";"EXPRESS_VOLGA" "3";"01.01.2017 00:00:00";"";"ForwardMobile" "4";"01.01.2017 00:00:00";"";"JCC" "5";"01.01.2017 00:00:00";"";"Kassa24" "6";"01.01.2017 00:00:00";"";"KAZKOMBANK" "7";"01.01.2017 00:00:00";"";"Krasplat" "8";"01.01.2017 00:00:00";"";"MINBANK" "9";"01.01.2017 00:00:00";"";"MKB_OSMP" "10";"01.01.2017 00:00:00";"";"OSMP_Amigo" "11";"01.01.2017 00:00:00";"";"OSMP_CHECK" "12";"01.01.2017 00:00:00";"";"OSMP_DELTAPAY" "13";"01.01.2017 00:00:00";"";"OSMP_EXPRESS_OPLATA" "14";"01.01.2017 00:00:00";"";"OSMP_INTERPAY" "15";"01.01.2017 00:00:00";"";"OSMP_MOROZOV" "16";"01.01.2017 00:00:00";"";"OSMP_QIWI" "17";"01.01.2017 00:00:00";"";"OSMP_SBRF" "18";"01.01.2017 00:00:00";"";"OSMP_SIPAY" "19";"01.01.2017 00:00:00";"";"PAYANYWAY" "20";"01.01.2017 00:00:00";"";"Payfon_phone" "21";"01.01.2017 00:00:00";"";"PAYKEEPER" "22";"01.01.2017 00:00:00";"";"PAYMASTER" "23";"01.01.2017 00:00:00";"";"PAYNET_UZ" "24";"01.01.2017 00:00:00";"";"PayPal" "25";"01.01.2017 00:00:00";"";"QIWI_OSMP" "26";"01.01.2017 00:00:00";"";"QIWI(REST)" "27";"01.01.2017 00:00:00";"";"Qiwiwallet" "28";"01.01.2017 00:00:00";"";"RAPIDA" "29";"01.01.2017 00:00:00";"";"SBERBANK_ACQ" "30";"01.01.2017 00:00:00";"";"SBRF_BS" "31";"01.01.2017 00:00:00";"";"SBRF_KIBERPLAT" "32";"01.01.2017 00:00:00";"";"TelePay" "33";"01.01.2017 00:00:00";"";"TINKOFF" "34";"01.01.2017 00:00:00";"";"UBRIR" "35";"01.01.2017 00:00:00";"";"UCS_ACQ" "36";"01.01.2017 00:00:00";"";"Uniteller" "37";"01.01.2017 00:00:00";"";"UnitellerAutopay" "38";"01.01.2017 00:00:00";"";"XPLAT" "39";"01.01.2017 00:00:00";"";"Поступление наличных" |
{code} |