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
フィーモデル締め [開発チーム]

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

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

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c7f2ebeb4f15d17e8057fdcc628bb077.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.

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

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

Deprecated: Function split() is deprecated in /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/inc/parser/lexer.php on line 517
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c7f2ebeb4f15d17e8057fdcc628bb077.i failed
Unable to save cache file. Hint: disk full; file permissions; safe_mode setting.
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c7f2ebeb4f15d17e8057fdcc628bb077.xhtml failed

2009/04/26 ~ 2009/05/25 21件を強制承認(ms_uniqnum=4736 株式会社しんわ様(4件)は強制承認対象外)

該当件数確認

SELECT
mpa_uniqnum,
mpa_apply_date,
mpa_apply_status
FROM
mall_product_apply
WHERE
mpa_apply_date >= '2009-04-26' AND
mpa_apply_date < '2009-05-26' AND
mpa_mpc_uniqnum > 0 AND
mpa_apply_status = 3 AND
mpa_mpc_uniqnum NOT IN(SELECT
mpc_uniqnum
FROM
mall_product_cate 
INNER JOIN mall_product 
ON mpc_mp_uniqnum = mp_uniqnum
WHERE
mp_ms_uniqnum IN(4736) -- 除外MS
)
ORDER BY
mpa_uniqnum

承認処理

UPDATE
mall_product_apply
SET
mpa_apply_status = 1,
mpa_apply_status_time = '2009-06-01' -- 承認日
WHERE
mpa_apply_date >= '2009-04-26' AND
mpa_apply_date < '2009-05-26' AND
mpa_mpc_uniqnum > 0 AND
mpa_apply_status = 3 AND
mpa_mpc_uniqnum NOT IN(SELECT
mpc_uniqnum
FROM
mall_product_cate 
INNER JOIN mall_product 
ON mpc_mp_uniqnum = mp_uniqnum
WHERE
mp_ms_uniqnum IN(4736) -- 除外MS
)
  1. WHERE文を同じにする

データ生成

SELECT
	ms_uniqnum,
	ms_name,--月額固定も追加
	ms_kana,
	ms_zip1,
	ms_zip2,
	ms_prefecture,
	ms_address,
	ms_building_name,
	ms_tel1,
	ms_tel2,
	ms_tel3,
	ms_charge_name,
	ms_charge_kana,
	ms_charge_post,
	ms_charge_executive,
	ms_charge_mail,
	ms_charge_tel1,
	ms_charge_tel2,
	ms_charge_tel3,
	ms_charge_zip1,
	ms_charge_zip2,
	ms_charge_prefecture,
	ms_charge_address,
	ms_charge_building_name,
	ms_contract_plan,
	ms_pay_plan,
	ms_demand_zip1,
	ms_demand_zip2,
	ms_demand_prefecture,
	ms_demand_address,
	ms_demand_building_name,
	ms_demand_name,
	mp_uniqnum,
	mp_check_reason,
	mp_cost_result_document,
	mp_cost_result_estimate,
	mp_cost_result_download,
	mp_cost_result_apply,
	mpc_uniqnum,
	mpc_cost_result_document,
	mpc_cost_result_estimate,
	mpc_cost_result_download,
	mpc_cost_result_apply,
	mpc_mp_name,
	mpa_uniqnum,
	mpa_apply_date,
	mc_name,
	mpa_mpc_uniqnum,
	mpa_mpc_incentive,
	mpa_apply_type,
	mpa_apply_status,
	mpa_me_uniqnum,
	mpa_co_name,
	mpa_me_name,
	mpa_me_mail,
	ms_cost_start,
	ms_cost_monthly,
	ms_cost_result_document,
	ms_cost_result_estimate,
	ms_cost_result_download,
	ms_cost_result_apply,
	mpa_mc_uniqnum,
	mc_sm_uniqnum,
	mpa_mit_me_uniqnum,
	ms_cost_monthly
FROM
	mall_supplier ms,
	mall_product mp,
	mall_category mc,
	mall_product_cate mpc,
	mall_product_apply mpa
WHERE
	ms.ms_uniqnum = mp.mp_ms_uniqnum AND
	mp.mp_uniqnum = mpc.mpc_mp_uniqnum AND
	mpa.mpa_mpc_uniqnum = mpc.mpc_uniqnum AND
	mpa.mpa_apply_date >= '20090426' AND
	mpa.mpa_apply_date < '20090526' AND
	mp.mp_sm_uniqnum = 3 AND
	mpa.mpa_mc_uniqnum NOT IN(40) AND
	mc.mc_uniqnum = mpa.mpa_mc_uniqnum
ORDER BY
	ms.ms_uniqnum,
	mp.mp_uniqnum,
	mpc.mpc_uniqnum
 
--
--ユニークキー mpa_apply_date,
--会社名
--会社名 ふりがな
--郵便番号1
--郵便番号2
--都道府県
--住所
--ビル名
--電話番号1
--電話番号2
--電話番号3
--担当者名
--担当者 ふりがな
--担当者 部署名
--担当者 役職名
--担当者 メールアドレス
--担当者 電話番号1
--担当者 電話番号2
--担当者 電話番号3
--担当者 郵便番号1
--担当者 郵便番号2
--担当者 都道府県
--担当者 住所
--担当者 ビル名
--契約基本プラン
--支払方法
--請求先郵便番号1
--請求先郵便番号2
--請求先都道府県
--請求先住所
--請求先ビル名
--宛名
--ユニークキー
--見直し理由
--資料成果
--見積成果
--ダウンロード成果
--申込成果
--ユニークキー
--資料成果
--見積成果
--ダウンロード成果
--申込成果
--商品名
--ユニークキー
--登録日時
--カテゴリuniqnum
--商品情報(カテ別)uniqnum
--報酬単価
--申込種別
--申込審査ステータス
--会員番号
--会員社名
--会員名前
--メアド
--初期費用
--月額費用
--資料成果
--見積成果
--ダウンロード成果
--申込成果
--カテゴリ番号
--カテゴリ種別(1,2が商談、3モール)

保存場所

フィーモデル締め.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