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
090707依頼 [開発チーム]
Writing /var/www/vhosts/w629.ws.domainking.cloud/enjoy-lei.com/dokuwiki/data/cache/c/c44b58afd6df4409e5a65a1e6def3203.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/c44b58afd6df4409e5a65a1e6def3203.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/c44b58afd6df4409e5a65a1e6def3203.xhtml failed

20090916依頼(アウトソーシング、フランチャイズ、ゼミナー)

 
 
--アウトソーシング
SELECT
	oss.oss_uniqnum ,
	oss.oss_ms_uniqnum ,
	oss.oss_reg_time  ,
	ms.ms_name,
	oss.oss_name  ,
	ms.ms_charge_name,
	ms.ms_tel1||'-'||ms.ms_tel2||'-'||ms.ms_tel3,
	ms_charge_mail
FROM
	out_source_service oss  
INNER JOIN mall_supplier ms  
ON oss_ms_uniqnum =  ms_uniqnum  
INNER JOIN me me  
ON ms_me_uniqnum = me_uniqnum  
INNER JOIN co co   
ON me_co_uniqnum = co_uniqnum
WHERE
	me.me_withdraw_flag = 1 AND
	ms.ms_osagr_status = 1 AND
	ms.ms_article_status IN (1,3) AND
	oss.oss_status  = 1 AND
	oss.oss_exam_status IN (1,2,3) AND
	'2009-09-16' <= oss.oss_end_time  AND
	oss.oss_reg_time >= '20090807'
 
--フランチャイズ掲載中
SELECT
	fd.fd_uniqnum ,
	fd.fd_ms_uniqnum ,
	fd.fd_reg_time ,
	ms.ms_name,
	fd.fd_name ,
	ms.ms_charge_name,
	ms.ms_tel1||'-'||ms.ms_tel2||'-'||ms.ms_tel3,
	ms_charge_mailFROMfc_detail fd	 
INNER JOIN  mall_supplier ms  
ON  	fd.fd_ms_uniqnum = ms.ms_uniqnum  	 
INNER JOIN  me me  
ON  	ms.ms_me_uniqnum = me.me_uniqnum  
INNER JOIN  co co  
ON  	me.me_co_uniqnum = co.co_uniqnum
WHERE
	fd.fd_reg_time >= '20090807'  AND
	fd.fd_approval_status = 1  AND
	fd.fd_user_status = 1  AND
	ms.ms_cancel_status = 1  AND
	ms.ms_approval_status = 5  AND
	me.me_withdraw_flag = 1 
ORDER BYfd.fd_ms_uniqnum,	fd.fd_uniqnum
 
--ゼミナー
SELECT
	sd.sd_uniqnum ,
	sd.sd_ms_uniqnum ,
	sd.sd_reg_time ,
	ms.ms_name,
	sd.sd_name,
	ms.ms_charge_name,
	ms.ms_tel1||'-'||ms.ms_tel2||'-'||ms.ms_tel3,
	ms_charge_mail
FROM
	seminar_detail sd 
INNER JOIN mall_supplier ms 
ON sd.sd_ms_uniqnum = ms.ms_uniqnum 
INNER JOIN me me 
ON ms.ms_me_uniqnum = me.me_uniqnum 
INNER JOIN co co 
ON me.me_co_uniqnum = co.co_uniqnum
WHERE
	sd.sd_approval_status = 1 AND
	sd.sd_user_status = 1 AND
	sd.sd_deadline >= '2009-09-16' AND
	ms.ms_cancel_status = 1 AND
	ms.ms_approval_status = 5 AND
	me.me_withdraw_flag = 1

依頼内容


◎リスト=1+2+3-4

1.アウトソーシング掲載者(受注者)
2.セミナー掲載者
3.職種が「営業・販売」
4.退会者&広告停止

希望期日:7/7 AM12:00
-- アウトソーシング受注者
SELECT
	*
FROM
	out_source_service oss
	INNER JOIN mall_supplier ms
	ON oss_ms_uniqnum = ms_uniqnum
	INNER JOIN me me
	ON ms_me_uniqnum = me_uniqnum
	INNER JOIN co co
	ON me_co_uniqnum = co_uniqnum
WHERE
	me.me_withdraw_flag = 1 AND
	ms.ms_osagr_status = 1 AND
	ms.ms_article_status IN (1,3) AND
	oss.oss_status = 1 AND
	oss.oss_exam_status IN (1,2,3) AND
	'2009-07-07' <= oss.oss_end_time
-- セミナー
SELECT
	*
FROM
seminar_detail sd
INNER JOIN mall_supplier ms
ON sd.sd_ms_uniqnum = ms.ms_uniqnum
INNER JOIN me me
ON ms.ms_me_uniqnum = me.me_uniqnum
INNER JOIN co co
ON me.me_co_uniqnum = co.co_uniqnum
WHERE
sd.sd_approval_status = 1 AND
sd.sd_user_status = 1 AND
sd.sd_deadline >= '2009-07-07' AND
ms.ms_cancel_status = 1 AND
ms.ms_approval_status = 5 AND
me.me_withdraw_flag = 1
090707依頼.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