<?php
namespace Home\Model;
use Think\Model\RelationModel;
class ScoresModel extends RelationModel{
protected $_li
'Staffs' => array(
'mapping_type' => self::HAS_ONE,
'class_name' => 'Staffs',
'foreign_key' => 'staffcode',
'as_fields' => 'staffname,deptcode',
),
);
}
?>
结果:
array(5) {
[0] => array(30) {
["_identify"] => string(2) "45"
["_locked"] => string(1) "0"
["_sortkey"] => string(16) "2.00000000000000"
["recordcode"] => string(9) "JL0000045"
["recordtime"] => string(23) "2014-12-29 00:00:00.000"
["staffcode"] => string(6) "339784"
["event"] => string(14) "迟到30分钟"
["eventtype"] => string(12) "考勤会务"
["eventscope"] => string(9) "流程内"
["eventremark"] => NULL
["incenttype"] => string(3) "扣"
["yscore"] => string(3) "3.0"
["xscore"] => string(3) "0.0"
["tvalue"] => NULL
["tscore"] => NULL
["transactor"] => NULL
["auditresult"] => NULL
["auditor"] => string(6) "254292"
["auditdate"] => NULL
["auditstate"] => NULL
["appealdate"] => NULL
["appealresult"] => NULL
["appealdealer"] => NULL
["appealdealdate"] => NULL
["appealdealremark"] => NULL
["isexchange"] => string(1) "0"
["recorder"] => string(5) "ricky"
["row_number"] => string(1) "1"
["staffname"] => NULL
["deptcode"] => NULL
}
[1] => array(30) {
["_identify"] => string(2) "42"
["_locked"] => string(1) "0"
["_sortkey"] => string(16) "1.00000000000000"
["recordcode"] => string(9) "JL0000042"
["recordtime"] => string(23) "2014-12-31 00:00:00.000"
["staffcode"] => string(6) "339156"
["event"] => string(24) "让顾客感动的事件"
["eventtype"] => string(15) "正能量事件"
["eventscope"] => string(9) "流程外"
["eventremark"] => NULL
["incenttype"] => string(3) "奖"
["yscore"] => string(3) "3.0"
["xscore"] => string(3) "0.0"
["tvalue"] => NULL
["tscore"] => NULL
["transactor"] => NULL
["auditresult"] => NULL
["auditor"] => NULL
["auditdate"] => NULL
["auditstate"] => NULL
["appealdate"] => NULL
["appealresult"] => NULL
["appealdealer"] => NULL
["appealdealdate"] => NULL
["appealdealremark"] => NULL
["isexchange"] => string(1) "0"
["recorder"] => string(5) "ricky"
["row_number"] => string(1) "2"
["staffname"] => NULL
["deptcode"] => NULL
}
log中的sql
SQL: SELECT column_name, data_type, column_default, is_nullable
FROM information_schema.tables AS t
JOIN information_schema.columns AS c
ON t.table_catalog = c.table_catalog
AND t.table_schema = c.table_schema
AND t.table_name = c.table_name
WHERE t.table_name = 'Staffs' [ RunTime:0.0003s ]
NOTIC: [8] Undefined index: id D:\MobileApp\ThinkPHPTest\ThinkPHP\Library\Think\Model\RelationModel.class.php 第 147 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0001s ]
NOTIC: [8] Undefined index: id D:\MobileApp\ThinkPHPTest\ThinkPHP\Library\Think\Model\RelationModel.class.php 第 147 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0001s ]
NOTIC: [8] Undefined index: id D:\MobileApp\ThinkPHPTest\ThinkPHP\Library\Think\Model\RelationModel.class.php 第 147 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0001s ]
NOTIC: [8] Undefined index: id D:\MobileApp\ThinkPHPTest\ThinkPHP\Library\Think\Model\RelationModel.class.php 第 147 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0001s ]
NOTIC: [8] Undefined index: id D:\MobileApp\ThinkPHPTest\ThinkPHP\Library\Think\Model\RelationModel.class.php 第 147 行.
SQL: SELECT T1.* FROM (SELECT thinkphp.*, ROW_NUMBER() OVER ( ORDER BY rand()) AS ROW_NUMBER FROM (SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )) AS thinkphp) AS T1 WHERE (T1.ROW_NUMBER BETWEEN 1 AND 1) [ RunTime:0.0001s ]
INFO: [ app_end ] --START--
INFO: Run Behavior\ShowPageTraceBehavior [ RunTime:0.000540s ]
INFO: [ app_end ] --END-- [ RunTime:0.000579s ]
为什么生成这样的SQL代码:
SELECT * FROM [Staffs] WHERE ( 1=1 AND staffcode='' )
staffcode明明有值的啊
最佳答案
