Code Context $clinic_info = $this->Clinic->find('all', array('conditions'=>array('id'=>$clinicId)));
$closestStation_info = $this->ClosestStation->find('all', array('conditions'=>array('clinic_id'=>$clinicId)));
$station_info = $this->Station->find('all', array('conditions'=>array('id'=>$closestStation_info[0]['Station']['id'])));
$clinicId = '333'
$cond = array(
(int) 0 => 'Impression.status = 1',
(int) 1 => 'User.del_flg is null',
(int) 2 => 'Impression.del_flg is null',
'User.clinic_id' => '333'
)
$firstId = (int) 0
$impression = array(
(int) 0 => array(
'Impression' => array(
'id' => '41',
'user_id' => '75',
'status' => '1',
'judge_ym' => '2014-04-01',
'raiin_day' => '2014-05-07',
'shinsatusken' => '',
'valuation_staff' => '4',
'valuation_doctor' => '3',
'valuation_time' => '4',
'valuation_facility' => '4',
'cmt' => 'とても良い天気の印象を持ってきたんじゃないかなものして、有るからそう感じているの音楽なんかなの音楽つぶやきます。',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-18 12:51:47',
'modified' => '2014-04-18 12:51:47',
'valuation' => (float) 3.5
),
'User' => array(
'id' => '75',
'clinic_id' => '333',
'clinic_name' => 'TEST',
'clinic_name_tmp' => 'TEST',
'seq' => '1397793107.28676',
'name' => 'ファミコン',
'shinryo_status' => '3',
'raiin_kbn' => '1',
'raiin_day' => '2014-05-07',
'age_lev' => null,
'sex' => '2',
'card_kbn' => null,
'post_no' => '',
'pref' => '',
'city' => '',
'address' => '',
'mail' => '',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-18 12:51:47',
'modified' => '2014-04-18 12:51:47'
),
'Reply' => array(
'id' => null,
'impression_id' => null,
'tokobi' => null,
'cmt' => null,
'del_flg' => null,
'updater' => null,
'created' => null,
'modified' => null
)
),
(int) 1 => array(
'Impression' => array(
'id' => '38',
'user_id' => '72',
'status' => '1',
'judge_ym' => '2014-04-01',
'raiin_day' => '2014-05-05',
'shinsatusken' => '12345678',
'valuation_staff' => '3',
'valuation_doctor' => '2',
'valuation_time' => '1',
'valuation_facility' => '2',
'cmt' => 'とても飲みやすく、さっぱりとしていてどんなお料理にもよく合うし、しかも飲んでいて存在感があるというのか…
うまく表現できませんが、我が家では、お祝い事の席にはこれを用意することが定番になっています（＾＾）
たまに、他の物を買ったりしますが、
みんなで「やっぱりモエがおいしいよね！」
という結論に達しています♪',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-16 16:31:43',
'modified' => '2014-04-16 16:31:43',
'valuation' => (float) 2
),
'User' => array(
'id' => '72',
'clinic_id' => '333',
'clinic_name' => 'TEST',
'clinic_name_tmp' => 'TEST',
'seq' => '1397633503.74626',
'name' => 'プレイス内から投稿',
'shinryo_status' => '3',
'raiin_kbn' => '1',
'raiin_day' => '2014-05-05',
'age_lev' => null,
'sex' => '2',
'card_kbn' => null,
'post_no' => '1410031',
'pref' => '東京都',
'city' => '品川区',
'address' => '西五反田',
'mail' => 'taniguchi-h@dym.jp',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-16 16:31:43',
'modified' => '2014-04-16 16:31:43'
),
'Reply' => array(
'id' => null,
'impression_id' => null,
'tokobi' => null,
'cmt' => null,
'del_flg' => null,
'updater' => null,
'created' => null,
'modified' => null
)
)
)
$row = array(
'Impression' => array(
'id' => '38',
'user_id' => '72',
'status' => '1',
'judge_ym' => '2014-04-01',
'raiin_day' => '2014-05-05',
'shinsatusken' => '12345678',
'valuation_staff' => '3',
'valuation_doctor' => '2',
'valuation_time' => '1',
'valuation_facility' => '2',
'cmt' => 'とても飲みやすく、さっぱりとしていてどんなお料理にもよく合うし、しかも飲んでいて存在感があるというのか…
うまく表現できませんが、我が家では、お祝い事の席にはこれを用意することが定番になっています（＾＾）
たまに、他の物を買ったりしますが、
みんなで「やっぱりモエがおいしいよね！」
という結論に達しています♪',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-16 16:31:43',
'modified' => '2014-04-16 16:31:43',
'valuation' => (float) 2
),
'User' => array(
'id' => '72',
'clinic_id' => '333',
'clinic_name' => 'TEST',
'clinic_name_tmp' => 'TEST',
'seq' => '1397633503.74626',
'name' => 'プレイス内から投稿',
'shinryo_status' => '3',
'raiin_kbn' => '1',
'raiin_day' => '2014-05-05',
'age_lev' => null,
'sex' => '2',
'card_kbn' => null,
'post_no' => '1410031',
'pref' => '東京都',
'city' => '品川区',
'address' => '西五反田',
'mail' => 'taniguchi-h@dym.jp',
'del_flg' => null,
'updater' => null,
'submit_type' => '2',
'created' => '2014-04-16 16:31:43',
'modified' => '2014-04-16 16:31:43'
),
'Reply' => array(
'id' => null,
'impression_id' => null,
'tokobi' => null,
'cmt' => null,
'del_flg' => null,
'updater' => null,
'created' => null,
'modified' => null
)
)
$valuation = (int) 2
$sql = ' SELECT COUNT(1) cnt, AVG(valuation_staff) v_staff, AVG(valuation_doctor) v_doctor, AVG(valuation_time) v_time, AVG(valuation_facility) v_facility FROM users User, impressions Impression WHERE User.clinic_id = ? AND User.id = Impression.user_id AND User.del_flg is null AND Impression.status = 1 AND Impression.del_flg is null'
$DBRst = array(
(int) 0 => array(
(int) 0 => array(
'cnt' => '2',
'v_staff' => '3.5000',
'v_doctor' => '2.5000',
'v_time' => '2.5000',
'v_facility' => '3.0000'
)
)
)
$rst = array(
'cnt' => '2',
'v_staff' => '3.5000',
'v_doctor' => '2.5000',
'v_time' => '2.5000',
'v_facility' => '3.0000'
)
$summary = array(
'cnt' => '2',
'v_staff' => (float) 3.5,
'v_doctor' => (float) 2.5,
'v_time' => (float) 2.5,
'v_facility' => (float) 3,
'valuation' => (float) 2.5
)
$clinic_info = array(
(int) 0 => array(
'Clinic' => array(
'id' => '333',
'status' => '1',
'contract_s' => null,
'contract_e' => null,
'press_page' => '1',
'name' => 'TEST',
'contact' => '0',
'post_no' => '1940041',
'pref' => '東京都',
'city' => '町田市',
'address' => '玉川学園',
'lat' => '35.5628303',
'lng' => '139.4632884',
'login_id' => '0101001',
'login_pass' => 'OCJoKsQ8OfUAwMgBLhgN',
'present_flg' => null,
'patient_flg' => null,
'animation_flg' => null,
'del_flg' => null,
'updater' => null,
'created' => '2014-03-05 16:20:36',
'modified' => '2014-03-05 16:20:51'
)
)
)
$closestStation_info = array()
PressesController::impression() - APP/Controller/PressesController.php, line 401
PressesController::beforeFilter() - APP/Controller/PressesController.php, line 145
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 246
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 669
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 183
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 161
[main] - APP/webroot/index.php, line 92
