CakePHP: the rapid development php framework: Farmers

Farmer

User Id: AG01001281
Agreement Start Day: 2017-09-25
Agreement End Day
Plan Code: 1
Agreement Amount: 0
Rental Printer Sn
Rental Tablet Sn
Rental Tablet Tel
Rental Tablet Gmail
Label Flg
Seal Flg
Blog Flg
Log Save Number: 5
User Post Number
User Address
User Tel
Qr Url
Notification File
Plain Password
Created: 2016-08-30 12:23:26
Insert User: MG00000001
Modified: 2017-09-25 11:25:04
Update User: AG01001281

Actions

Related Contractors

Id	Farmer Id	Trader Id	Company Cd	Created	Insert User	Modified	Update User	Actions
6621	AG01001281	01	005	2017-10-20 19:37:32	MG00000001	2017-10-20 19:37:32	MG00000001	View Edit Delete
5451	AG01001281	01	006	2017-02-24 00:00:00	MG00000001			View Edit Delete

New Contractor

Related Farmer Products

Id Farmer Id Trader Id Cmp Product Id Company Cd Co Product Cd Sys Product Cd Display Product Nm Display Product Fk Display Locality Farmer Edit Flg Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Shipment Start Month Shipment End Month Use Start Day Use End Day Del Flg Created Insert User Modified Update User Actions

8513

AG01001281

2553

006

7109

90001

野菜

やさい

徳島県

Notice (8): Undefined index: farmer_edit_flg [APP/View/Farmers/view.ctp, line 357]Code Context            <td><?php echo $farmerProduct['display_product_fk']; ?></td>
            <td><?php echo $farmerProduct['display_locality']; ?></td>
            <td><?php echo $farmerProduct['farmer_edit_flg']; ?></td>
$viewFile = '/var/www/release/hounotori/app/View/Farmers/view.ctp'
$dataForView = array(
	'debugToolbarPanels' => array(
		'history' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'history_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'session' => array(
			'content' => null,
			'elementName' => 'session_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'request' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'request_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'sql_log' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'sql_log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'timer' => array(
			'content' => null,
			'elementName' => 'timer_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'log' => array(
			'content' => object(DebugKitLog) {},
			'elementName' => 'log_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'variables' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'variables_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'environment' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'environment_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		),
		'include' => array(
			'content' => array(
				[maximum depth reached]
			),
			'elementName' => 'include_panel',
			'plugin' => 'DebugKit',
			'title' => null,
			'disableTimer' => true
		)
	),
	'debugToolbarJavascript' => array(
		'libs' => 'DebugKit./js/js_debug_toolbar'
	),
	'debugToolbarCss' => array(
		(int) 0 => 'DebugKit./css/debug_toolbar.css'
	),
	'farmer' => array(
		'Farmer' => array(
			'user_id' => 'AG01001281',
			'agreement_start_day' => '2017-09-25',
			'agreement_end_day' => null,
			'plan_code' => '1',
			'agreement_amount' => '0',
			'rental_printer_sn' => '',
			'rental_tablet_sn' => '',
			'rental_tablet_tel' => '',
			'rental_tablet_gmail' => '',
			'label_flg' => null,
			'seal_flg' => null,
			'blog_flg' => null,
			'log_save_number' => '5',
			'user_post_number' => '',
			'user_address' => '',
			'user_tel' => '',
			'qr_url' => null,
			'notification_file' => null,
			'plain_password' => null,
			'admin_memo' => '徳島市集荷場利用生産者',
			'biz_browser_authorized_devices_count' => '1',
			'biz_browser_authorized_devices_limit' => '30',
			'created' => '2016-08-30 12:23:26',
			'insert_user' => 'MG00000001',
			'modified' => '2017-09-25 11:25:04',
			'update_user' => 'AG01001281'
		),
		'ContractPlan' => array(
			'plan_code' => '1',
			'plan_nm' => 'フルレンタル1年プラン',
			'contract_months' => '12',
			'agreement_amount' => '6800',
			'created' => '2016-08-26 17:04:06',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-26 17:04:06',
			'update_user' => 'MG00000001'
		),
		'User' => array(
			'password' => '*****',
			'id' => 'AG01001281',
			'login_id' => '01001281',
			'user_nm' => 'T仁木農園',
			'user_fk' => 'にきのうえん',
			'user_type' => '01',
			'mail_address_1' => '',
			'mail_address_2' => null,
			'login_rock_flg' => '0',
			'last_login_day' => '2017-09-25 11:35:07',
			'use_start_day' => '2016-08-29 00:00:00',
			'use_end_day' => null,
			'del_flg' => '0',
			'init_pass_flg' => '0',
			'created' => '2016-08-30 12:23:26',
			'insert_user' => 'MG00000001',
			'modified' => '2017-09-25 11:34:31',
			'update_user' => 'MG00000001'
		),
		'Contractor' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			)
		),
		'ExchangeLabelRollLog' => array(),
		'FarmerProduct' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'UsersPickupPoint' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		),
		'Trader' => array(
			(int) 0 => array(
				[maximum depth reached]
			)
		)
	)
)
$debugToolbarPanels = array(
	'history' => array(
		'content' => array(
			(int) 0 => array(
				[maximum depth reached]
			),
			(int) 1 => array(
				[maximum depth reached]
			),
			(int) 2 => array(
				[maximum depth reached]
			),
			(int) 3 => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'history_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'session' => array(
		'content' => null,
		'elementName' => 'session_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'request' => array(
		'content' => array(
			'params' => array(
				[maximum depth reached]
			),
			'url' => 'Farmers/view/AG01001281',
			'query' => array([maximum depth reached]),
			'data' => array([maximum depth reached]),
			'get' => array([maximum depth reached]),
			'currentRoute' => object(CakeRoute) {}
		),
		'elementName' => 'request_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'sql_log' => array(
		'content' => array(
			'connections' => array(
				[maximum depth reached]
			),
			'threshold' => (int) 20
		),
		'elementName' => 'sql_log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'timer' => array(
		'content' => null,
		'elementName' => 'timer_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'log' => array(
		'content' => object(DebugKitLog) {},
		'elementName' => 'log_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'variables' => array(
		'content' => array(
			'farmer' => array(
				[maximum depth reached]
			),
			'$request->data' => array([maximum depth reached])
		),
		'elementName' => 'variables_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'environment' => array(
		'content' => array(
			'php' => array(
				[maximum depth reached]
			),
			'cake' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'environment_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	),
	'include' => array(
		'content' => array(
			'core' => array(
				[maximum depth reached]
			),
			'app' => array(
				[maximum depth reached]
			),
			'plugins' => array(
				[maximum depth reached]
			),
			'paths' => array(
				[maximum depth reached]
			)
		),
		'elementName' => 'include_panel',
		'plugin' => 'DebugKit',
		'title' => null,
		'disableTimer' => true
	)
)
$debugToolbarJavascript = array(
	'libs' => 'DebugKit./js/js_debug_toolbar'
)
$debugToolbarCss = array(
	(int) 0 => 'DebugKit./css/debug_toolbar.css'
)
$farmer = array(
	'Farmer' => array(
		'user_id' => 'AG01001281',
		'agreement_start_day' => '2017-09-25',
		'agreement_end_day' => null,
		'plan_code' => '1',
		'agreement_amount' => '0',
		'rental_printer_sn' => '',
		'rental_tablet_sn' => '',
		'rental_tablet_tel' => '',
		'rental_tablet_gmail' => '',
		'label_flg' => null,
		'seal_flg' => null,
		'blog_flg' => null,
		'log_save_number' => '5',
		'user_post_number' => '',
		'user_address' => '',
		'user_tel' => '',
		'qr_url' => null,
		'notification_file' => null,
		'plain_password' => null,
		'admin_memo' => '徳島市集荷場利用生産者',
		'biz_browser_authorized_devices_count' => '1',
		'biz_browser_authorized_devices_limit' => '30',
		'created' => '2016-08-30 12:23:26',
		'insert_user' => 'MG00000001',
		'modified' => '2017-09-25 11:25:04',
		'update_user' => 'AG01001281'
	),
	'ContractPlan' => array(
		'plan_code' => '1',
		'plan_nm' => 'フルレンタル1年プラン',
		'contract_months' => '12',
		'agreement_amount' => '6800',
		'created' => '2016-08-26 17:04:06',
		'insert_user' => 'MG00000001',
		'modified' => '2016-08-26 17:04:06',
		'update_user' => 'MG00000001'
	),
	'User' => array(
		'password' => '*****',
		'id' => 'AG01001281',
		'login_id' => '01001281',
		'user_nm' => 'T仁木農園',
		'user_fk' => 'にきのうえん',
		'user_type' => '01',
		'mail_address_1' => '',
		'mail_address_2' => null,
		'login_rock_flg' => '0',
		'last_login_day' => '2017-09-25 11:35:07',
		'use_start_day' => '2016-08-29 00:00:00',
		'use_end_day' => null,
		'del_flg' => '0',
		'init_pass_flg' => '0',
		'created' => '2016-08-30 12:23:26',
		'insert_user' => 'MG00000001',
		'modified' => '2017-09-25 11:34:31',
		'update_user' => 'MG00000001'
	),
	'Contractor' => array(
		(int) 0 => array(
			'id' => '6621',
			'farmer_id' => 'AG01001281',
			'trader_id' => '01',
			'company_cd' => '005',
			'created' => '2017-10-20 19:37:32',
			'insert_user' => 'MG00000001',
			'modified' => '2017-10-20 19:37:32',
			'update_user' => 'MG00000001'
		),
		(int) 1 => array(
			'id' => '5451',
			'farmer_id' => 'AG01001281',
			'trader_id' => '01',
			'company_cd' => '006',
			'created' => '2017-02-24 00:00:00',
			'insert_user' => 'MG00000001',
			'modified' => null,
			'update_user' => null
		)
	),
	'ExchangeLabelRollLog' => array(),
	'FarmerProduct' => array(
		(int) 0 => array(
			'id' => '8513',
			'farmer_id' => 'AG01001281',
			'trader_id' => '01',
			'cmp_product_id' => '2553',
			'company_cd' => '006',
			'co_product_cd' => '7109',
			'sys_product_cd' => '90001',
			'display_product_nm' => '野菜',
			'display_product_fk' => 'やさい',
			'display_locality' => '徳島県',
			'farmer_edit_status' => '1',
			'brc_shipment_product_characters' => '7',
			'brc_shipment_product_cd' => '0217109',
			'brc_price_cd' => '1',
			'brc_price_characters' => '4',
			'company_shipment_cd' => '7109',
			'brc_type_flag' => null,
			'brc_mid_flag' => null,
			'val_pos_pattern' => null,
			'mid_checkdigit_flag' => null,
			'shipment_start_month' => '1',
			'shipment_end_month' => '12',
			'use_start_day' => '2017-02-27 00:00:00',
			'use_end_day' => null,
			'del_flg' => '0',
			'created' => '2017-02-24 00:00:00',
			'insert_user' => 'MG00000001',
			'modified' => null,
			'update_user' => 'MG00000001'
		)
	),
	'UsersPickupPoint' => array(
		(int) 0 => array(
			'farmer_id' => 'AG01001281',
			'pickup_point_id' => '48',
			'use_start_day' => '2016-07-01 00:00:00',
			'use_end_day' => '2016-07-31 00:00:00',
			'created' => '2016-08-30 12:23:42',
			'insert_user' => 'MG00000001',
			'modified' => '2017-10-20 19:37:26',
			'update_user' => 'MG00000001'
		)
	),
	'Trader' => array(
		(int) 0 => array(
			'id' => '01',
			'formal_trader_nm' => '三井食品',
			'formal_trader_fk' => '三井食品',
			'designation_file' => '',
			'use_start_day' => '2016-08-26 17:04:05',
			'use_end_day' => null,
			'margin_price_yen' => '0',
			'created' => '2016-08-26 17:04:05',
			'insert_user' => 'MG00000001',
			'modified' => '2016-08-26 17:04:05',
			'update_user' => 'MG00000001',
			'TradersFarmer' => array(
				[maximum depth reached]
			)
		)
	)
)
$contractor = array(
	'id' => '5451',
	'farmer_id' => 'AG01001281',
	'trader_id' => '01',
	'company_cd' => '006',
	'created' => '2017-02-24 00:00:00',
	'insert_user' => 'MG00000001',
	'modified' => null,
	'update_user' => null
)
$farmerProduct = array(
	'id' => '8513',
	'farmer_id' => 'AG01001281',
	'trader_id' => '01',
	'cmp_product_id' => '2553',
	'company_cd' => '006',
	'co_product_cd' => '7109',
	'sys_product_cd' => '90001',
	'display_product_nm' => '野菜',
	'display_product_fk' => 'やさい',
	'display_locality' => '徳島県',
	'farmer_edit_status' => '1',
	'brc_shipment_product_characters' => '7',
	'brc_shipment_product_cd' => '0217109',
	'brc_price_cd' => '1',
	'brc_price_characters' => '4',
	'company_shipment_cd' => '7109',
	'brc_type_flag' => null,
	'brc_mid_flag' => null,
	'val_pos_pattern' => null,
	'mid_checkdigit_flag' => null,
	'shipment_start_month' => '1',
	'shipment_end_month' => '12',
	'use_start_day' => '2017-02-27 00:00:00',
	'use_end_day' => null,
	'del_flg' => '0',
	'created' => '2017-02-24 00:00:00',
	'insert_user' => 'MG00000001',
	'modified' => null,
	'update_user' => 'MG00000001'
)
include - APP/View/Farmers/view.ctp, line 357
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::render() - CORE/Cake/View/View.php, line 473
Controller::render() - CORE/Cake/Controller/Controller.php, line 963
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 200
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 111

0217109

2017-02-27 00:00:00

2017-02-24 00:00:00

MG00000001

View Edit Delete

New Farmer Product

Related Users Pickup Points

Farmer Id	Pickup Point Id	Use Start Day	Use End Day	Created	Insert User	Modified	Update User	Actions
AG01001281	48	2016-07-01 00:00:00	2016-07-31 00:00:00	2016-08-30 12:23:42	MG00000001	2017-10-20 19:37:26	MG00000001	View Edit Delete

New Users Pickup Point

(default) 7 queries took 1 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` WHERE `Farmer`.`user_id` = 'AG01001281'	1	1	0
2	SELECT `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE `Farmer`.`user_id` = 'AG01001281' LIMIT 1	1	1	1
3	SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` WHERE `Contractor`.`farmer_id` = ('AG01001281')	2	2	0
4	SELECT `ExchangeLabelRollLog`.`exchange_number`, `ExchangeLabelRollLog`.`farmer_id`, `ExchangeLabelRollLog`.`pickup_point_id`, `ExchangeLabelRollLog`.`exchange_label_roll`, `ExchangeLabelRollLog`.`acceptance_label_roll`, `ExchangeLabelRollLog`.`exchange_date`, `ExchangeLabelRollLog`.`acceptance_date`, `ExchangeLabelRollLog`.`exchange_user_id`, `ExchangeLabelRollLog`.`created`, `ExchangeLabelRollLog`.`insert_user`, `ExchangeLabelRollLog`.`modified`, `ExchangeLabelRollLog`.`update_user` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` WHERE `ExchangeLabelRollLog`.`farmer_id` = ('AG01001281')	0	0	0
5	SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` WHERE `FarmerProduct`.`farmer_id` = ('AG01001281')	1	1	0
6	SELECT `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` WHERE `UsersPickupPoint`.`farmer_id` = ('AG01001281')	1	1	0
7	SELECT `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user` FROM `sato_agri`.`traders` AS `Trader` JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = 'AG01001281' AND `TradersFarmer`.`trader_id` = `Trader`.`id`)	1	1	0

(default) 7 queries took 1 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `sato_agri`.`farmers` AS `Farmer` WHERE `Farmer`.`user_id` = 'AG01001281'

SELECT `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`update_user`, `ContractPlan`.`plan_code`, `ContractPlan`.`plan_nm`, `ContractPlan`.`contract_months`, `ContractPlan`.`agreement_amount`, `ContractPlan`.`created`, `ContractPlan`.`insert_user`, `ContractPlan`.`modified`, `ContractPlan`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user` FROM `sato_agri`.`farmers` AS `Farmer` LEFT JOIN `sato_agri`.`contract_plan` AS `ContractPlan` ON (`Farmer`.`plan_code` = `ContractPlan`.`plan_code`) LEFT JOIN `sato_agri`.`users` AS `User` ON (`User`.`id` = `Farmer`.`user_id`) WHERE `Farmer`.`user_id` = 'AG01001281' LIMIT 1

SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`update_user` FROM `sato_agri`.`contractors` AS `Contractor` WHERE `Contractor`.`farmer_id` = ('AG01001281')

SELECT `ExchangeLabelRollLog`.`exchange_number`, `ExchangeLabelRollLog`.`farmer_id`, `ExchangeLabelRollLog`.`pickup_point_id`, `ExchangeLabelRollLog`.`exchange_label_roll`, `ExchangeLabelRollLog`.`acceptance_label_roll`, `ExchangeLabelRollLog`.`exchange_date`, `ExchangeLabelRollLog`.`acceptance_date`, `ExchangeLabelRollLog`.`exchange_user_id`, `ExchangeLabelRollLog`.`created`, `ExchangeLabelRollLog`.`insert_user`, `ExchangeLabelRollLog`.`modified`, `ExchangeLabelRollLog`.`update_user` FROM `sato_agri`.`exchange_label_roll_logs` AS `ExchangeLabelRollLog` WHERE `ExchangeLabelRollLog`.`farmer_id` = ('AG01001281')

SELECT `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`farmer_products` AS `FarmerProduct` WHERE `FarmerProduct`.`farmer_id` = ('AG01001281')

SELECT `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` WHERE `UsersPickupPoint`.`farmer_id` = ('AG01001281')

SELECT `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user`, `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`update_user` FROM `sato_agri`.`traders` AS `Trader` JOIN `sato_agri`.`traders_farmers` AS `TradersFarmer` ON (`TradersFarmer`.`farmer_id` = 'AG01001281' AND `TradersFarmer`.`trader_id` = `Trader`.`id`)

Message	Memory use
Component initialization	3.56 MB
Controller action start	3.79 MB
Controller render start	6.37 MB
View render complete	7.84 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.66
Event: Controller.initialize	0.03
Event: Controller.startup	0.23
Controller action	24.92
Event: Controller.beforeRender	27.12
» Processing toolbar data	27.03
Rendering View	6.82
» Event: View.beforeRender	0.03
» Rendering APP/View/Farmers/view.ctp	5.22
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.87
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.26
Event: View.afterLayout	0.00

Constant	Value
BACKUP_DIR	/var/www/release/hounotori/app/tmp/backup
IMPORT_DIR	/var/www/webdav/mab

Constant	Value
APP	/var/www/release/hounotori/app/
APP_DIR	app
APPLIBS	/var/www/release/hounotori/app/Lib/
CACHE	/var/www/release/hounotori/app/tmp/cache/
CAKE	/var/www/release/hounotori/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/release/hounotori/lib
CORE_PATH	/var/www/release/hounotori/lib/
CAKE_VERSION	2.8.5
CSS	/var/www/release/hounotori/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://202.222.80.41
IMAGES	/var/www/release/hounotori/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/release/hounotori/app/webroot/js/
JS_URL	js/
LOGS	/var/www/release/hounotori/app/tmp/logs/
ROOT	/var/www/release/hounotori
TESTS	/var/www/release/hounotori/app/Test/
TMP	/var/www/release/hounotori/app/tmp/
VENDORS	/var/www/release/hounotori/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/release/hounotori/app/webroot/

Environment Variable	Value
Php Version	5.6.40
User	apache
Home	/usr/share/httpd
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	aA1jJyZo1@eGX45RglpAfQAAAFU
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aA1jJyZo1@eGX45RglpAfQAAAFU
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aA1jJyZo1@eGX45RglpAfQAAAFU
Kounotori Deploy Env	stg
Proxy-nokeepalive	1
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept Encoding	gzip, br, zstd, deflate
Http Host	202.222.80.41
Http Via	1.1 ip-10-7-69-108.us-east-2.compute.internal (squid/6.10)
Http X Forwarded For	10.2.53.173
Http Cache Control	max-age=259200
Http Connection	keep-alive
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache/2.4.37 (Red Hat Enterprise Linux) OpenSSL/1.1.1g
Server Name	202.222.80.41
Server Addr	192.168.1.3
Server Port	80
Remote Addr	160.79.110.201
Document Root	/var/www/html
Request Scheme	http
Context Prefix
Context Document Root	/var/www/html
Server Admin	admin@agri-harvest.sato.co.jp
Script Filename	/var/www/html/app/webroot/index.php
Remote Port	33632
Redirect Url	/app/webroot/Farmers/view/AG01001281
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/Farmers/view/AG01001281
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1745707815.58
Request Time	1745707815

CakePHP: the rapid development php framework

Farmer

Actions

Related Users

Related Contractors

Related Exchange Label Roll Logs

Related Farmer Products

Related Users Pickup Points

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files