Strict Standards: Declaration of action_plugin_blog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/blog/action.php on line 13

Strict Standards: Declaration of action_plugin_indexmenu::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/indexmenu/action.php on line 13

Strict Standards: Declaration of action_plugin_importoldchangelog::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldchangelog/action.php on line 8

Strict Standards: Declaration of action_plugin_importoldindex::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/importoldindex/action.php on line 8

Strict Standards: Declaration of action_plugin_include::register() should be compatible with DokuWiki_Action_Plugin::register($controller) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/lib/plugins/include/action.php on line 19

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 208

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 211

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 421

Deprecated: Assigning the return value of new by reference is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parserutils.php on line 594

Strict Standards: Declaration of cache_instructions::retrieveCache() should be compatible with cache::retrieveCache($clean = true) in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/cache.php on line 291

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/auth.php on line 154

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 73
締め処理2009年08月分 [開発チーム]

締め処理2009年08月分

Gサーチから月次データを持ってくる

cd /home/fideli/businessdataBin/
perl monthly_payment.pl

- Gサーチデータ確認

cd /home/fideli/businessdataBin/log
./logview.sh eclmk200908.plain
99999999999999,936,394645,,,,,,,,,,,,,

Gサーチ以外確認 < 10件、22,000円 >

select count(*) from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_dp_uniqnum <> 9999
select * from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_dp_uniqnum <> 9999

Gサーチ以外(未処理データ:1) < 4件、16,000円 >

select count(*) from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_status = 1
and df_dp_uniqnum <> 9999
select * from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_status = 1
and df_dp_uniqnum <> 9999

Gサーチ以外(処理済データ:2)< 6件、6,000円 >

select count(*) from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_status <> 1
and df_dp_uniqnum <> 9999
select * from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
and df_status <> 1
and df_dp_uniqnum <> 9999

データ確認 < 22,300円 >

select
df_uniqnum,
df_dfh_uniqnum,
df_status,
df_reg_time,
df_dp_uniqnum,
df_price,
df_dp_reward,
df_p_dpp_uniqnum,
df_dpg_uniqnum
from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
order by df_dp_uniqnum

商品データ追加

db_fee getDpUniqnum error QJTT,,13859,QJTT,ジェトロ通商公報,20090817,234016,,,01,記事見出し,1,,20,20,,
http://test2.fideli.com/dbkanri/
http://www.fideli.com/dbkanri/
select * from db_product
where dp_dbid in (
'QJTT'
)

Gサーチデータ取り込み

cd /home/fideli/businessdataBin
php businessdataGsearchMonth.php
php businessdataGsearchMonth.php honban

データ確認(未処理) <940件、41,0645円>

select count(*) from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_status = 1
and df_me_uniqnum <> 3
select df_dm_uniqnum, sum(df_num * df_price) as total from db_fee
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_status = 1
and df_me_uniqnum <> 3
group by df_dm_uniqnum
order by df_dm_uniqnum

名前確認

select df_dm_uniqnum, df_me_uniqnum, me_name, dm_rep_name, dm_charge_name,
pm_card_name, dm_name, sum(df_num * df_price) as total
from db_fee
left join db_member on df_dm_uniqnum = dm_uniqnum
left join me on df_me_uniqnum = me_uniqnum
left join pay_master on df_dm_uniqnum = pm_dm_uniqnum
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_status = 1
and df_me_uniqnum <> 3
group by df_dm_uniqnum, df_me_uniqnum, me_name, dm_name, dm_rep_name,
dm_charge_name, pm_card_name
order by df_dm_uniqnum

カード会社の画面を開く(本番では省略)

https://gpay-test.kessai.ne.jp:24443/kanri/shop/dGVzdHBnMDAwMDc2Mw==/index.php

A01-1750-0 即時売上 1,260 2009/08/05 14:49:36 2009/08/05 14:49:36

logファイルのパーミッション変更する

権限がapacheの場合rootで変更して下さい

cd /var/www/fds/gpay_client
chmod 666 gpayclient.log

締め処理(94件)

php businessdataMonthly.php
php businessdataMonthly.php honban

logファイルのパーミッション戻す

権限がapacheの場合rootで変更して下さい

cd /var/www/fds/gpay_client
chmod 元の状態 gpayclient.log

確認 < 437,470円 >

select df_dm_uniqnum, df_me_uniqnum, me_name, dm_rep_name, dm_charge_name,
pm_card_name, dm_name, sum(df_num * df_price) as total
from db_fee
left join db_member on df_dm_uniqnum = dm_uniqnum
left join me on df_me_uniqnum = me_uniqnum
left join pay_master on df_dm_uniqnum = pm_dm_uniqnum
where df_reg_time >= '2009-08-01'
and df_reg_time < '2009-09-01'
and df_me_uniqnum <> 3
group by df_dm_uniqnum, df_me_uniqnum, me_name, dm_name, dm_rep_name,
dm_charge_name, pm_card_name
order by df_dm_uniqnum

NGカードリスト

http://test2.fideli.com/dbkanri/?id=ngCardList
http://www.fideli.com/dbkanri/?id=ngCardList

パートナーデータ

php businessdataPartner.php month
締め処理2009年08月分.txt · 最終更新: 2010/07/27 15:46 (外部編集)
www.chimeric.de Creative Commons License Valid CSS Driven by DokuWiki do yourself a favour and use a real browser - get firefox!! Recent changes RSS feed Valid XHTML 1.0

Strict Standards: Only variables should be passed by reference in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/doku.php on line 81