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
db締め処理2009年11月分 [開発チーム]

db締め処理2009年11月分

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

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

- Gサーチデータ確認

cd /home/fideli/businessdataBin/log
./logview.sh eclmk200911.plain
99999999999999,763,414225,,,,,,,,,,,,,

Gサーチ以外確認(6件、11,800円)

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

Gサーチ以外(未処理データ:1) (2件、8,000円)

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

Gサーチ以外(処理済データ:2)(4件、3,800円)

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

データ確認 (57,675円)

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-11-01'
and df_reg_time < '2009-12-01'
order by df_dp_uniqnum

Gサーチデータ取り込み

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

データ追加

db_fee getDpUniqnum error QCBN,,9586,QCBN,CB医療介護ニュース,20091105,174129,,,01,記事見出し,2,,10,20,,
171

db_fee getDpUniqnum error QCBN,,9586,QCBN,CB医療介護ニュース,20091105,174421,,,01,記事見出し,3,,10,30,,
189

db_fee getDpUniqnum error QSHE,,1037525,QSHE,シェアーズ企業財務情報グラフパック,20091125,204211,,,02,レポート表示,1,,500,500,,
665

http://www.fideli.com/dbkanri/

データ確認(未処理データ合計:674件、409,925円)

select count(*) from db_fee
where df_reg_time >= '2009-11-01'
and df_reg_time < '2009-12-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-11-01'
and df_reg_time < '2009-12-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-11-01'
and df_reg_time < '2009-12-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-1927-0 即時売上 1,260 2009/10/05 11:56:24 2009/10/05 11:56:25

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

確認(447,118円)

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-11-01'
and df_reg_time < '2009-12-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://www.fideli.com/dbkanri/?id=ngCardList

パートナーデータ

php businessdataPartner.php month
db締め処理2009年11月分.txt · 最終更新: 2010/07/27 15:47 (外部編集)
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