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年06月分 [開発チーム]

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

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

Gサーチデータ確認

cd /home/fideli/businessdataBin/log
./logview.sh eclmk200906.plain
99999999999999,1658,387730,,,,,,,,,,,,,

Gサーチ以外確認

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

Gサーチ以外(未処理データ:1)

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

Gサーチ以外(処理済データ:2)

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

データ確認

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

Gサーチデータ取り込み

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

データ確認(未処理データ合計:1662)

select count(*) from db_fee
where df_reg_time >= '2009-06-01'
and df_reg_time < '2009-07-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-06-01'
and df_reg_time < '2009-07-01'
and df_status = 1
and df_me_uniqnum <> 3
group by df_dm_uniqnum
order by df_dm_uniqnum

上記をexcelに貼り付けて計算(403,730円)

名前確認

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-06-01'
and df_reg_time < '2009-07-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-1473-0 即時売上 84 2009/06/04 11:23:31 2009/06/04 11:23:32

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

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

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

締め処理(83件)

php businessdataMonthly.php
php businessdataMonthly.php honban

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

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

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

確認(551484円)

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-06-01'
and df_reg_time < '2009-07-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カードリスト

パートナーデータ

php businessdataPartner.php month

db締め処理2009年06月分.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