CakePHP: the rapid development php framework: CmpProducts

Cmp Product

Id: 17427
Trader Id: 01
Company Cd: 911
Co Product Cd: 103773
Co Product Nm: 農産物69
Co Product Reciept Nm
Co Product Fk: のうさんぶつ
Limited User Id
Use Start Day: 2022-11-01 00:00:00
Use End Day
Created: 2022-11-01 13:43:13
Insert User: MG00000001
Modified: 2022-11-01 13:43:13
Update User: MG00000001

Actions

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

1560381

AG01005104

17427

911

103773

46000

赤かぶ

あかかぶ

長崎県

Notice (8): Undefined index: farmer_edit_flg [APP/View/CmpProducts/view.ctp, line 130]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/CmpProducts/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'
	),
	'cmpProduct' => array(
		'CmpProduct' => array(
			'id' => '17427',
			'trader_id' => '01',
			'company_cd' => '911',
			'co_product_cd' => '103773',
			'co_product_nm' => '農産物69',
			'co_product_reciept_nm' => '',
			'co_product_fk' => 'のうさんぶつ',
			'sys_product_cd' => '90000',
			'farmer_linked_flag' => '1',
			'limited_user_id' => '',
			'barcode_generate_pattern' => '0',
			'barcode_display_format' => '1',
			'use_start_day' => '2022-11-01 00:00:00',
			'use_end_day' => null,
			'created' => '2022-11-01 13:43:13',
			'insert_user' => 'MG00000001',
			'modified' => '2022-11-01 13:43:13',
			'update_user' => 'MG00000001'
		),
		'FarmerProduct' => 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' => 'cmp_products/view/17427',
			'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(
			'cmpProduct' => 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'
)
$cmpProduct = array(
	'CmpProduct' => array(
		'id' => '17427',
		'trader_id' => '01',
		'company_cd' => '911',
		'co_product_cd' => '103773',
		'co_product_nm' => '農産物69',
		'co_product_reciept_nm' => '',
		'co_product_fk' => 'のうさんぶつ',
		'sys_product_cd' => '90000',
		'farmer_linked_flag' => '1',
		'limited_user_id' => '',
		'barcode_generate_pattern' => '0',
		'barcode_display_format' => '1',
		'use_start_day' => '2022-11-01 00:00:00',
		'use_end_day' => null,
		'created' => '2022-11-01 13:43:13',
		'insert_user' => 'MG00000001',
		'modified' => '2022-11-01 13:43:13',
		'update_user' => 'MG00000001'
	),
	'FarmerProduct' => array(
		(int) 0 => array(
			'id' => '1560381',
			'farmer_id' => 'AG01005104',
			'trader_id' => '01',
			'cmp_product_id' => '17427',
			'company_cd' => '911',
			'co_product_cd' => '103773',
			'sys_product_cd' => '46000',
			'display_product_nm' => '赤かぶ',
			'display_product_fk' => 'あかかぶ',
			'display_locality' => '長崎県',
			'farmer_edit_status' => '1',
			'brc_shipment_product_characters' => '8',
			'brc_shipment_product_cd' => '25103773',
			'brc_price_cd' => '0',
			'brc_price_characters' => '4',
			'company_shipment_cd' => '1',
			'brc_type_flag' => null,
			'brc_mid_flag' => '',
			'val_pos_pattern' => null,
			'mid_checkdigit_flag' => null,
			'shipment_start_month' => '1',
			'shipment_end_month' => '12',
			'use_start_day' => '2022-11-01 00:00:00',
			'use_end_day' => null,
			'del_flg' => '0',
			'created' => '2022-11-01 15:50:57',
			'insert_user' => 'MG00000001',
			'modified' => '2023-11-27 10:25:13',
			'update_user' => 'AG01005104'
		)
	)
)
$farmerProduct = array(
	'id' => '1560381',
	'farmer_id' => 'AG01005104',
	'trader_id' => '01',
	'cmp_product_id' => '17427',
	'company_cd' => '911',
	'co_product_cd' => '103773',
	'sys_product_cd' => '46000',
	'display_product_nm' => '赤かぶ',
	'display_product_fk' => 'あかかぶ',
	'display_locality' => '長崎県',
	'farmer_edit_status' => '1',
	'brc_shipment_product_characters' => '8',
	'brc_shipment_product_cd' => '25103773',
	'brc_price_cd' => '0',
	'brc_price_characters' => '4',
	'company_shipment_cd' => '1',
	'brc_type_flag' => null,
	'brc_mid_flag' => '',
	'val_pos_pattern' => null,
	'mid_checkdigit_flag' => null,
	'shipment_start_month' => '1',
	'shipment_end_month' => '12',
	'use_start_day' => '2022-11-01 00:00:00',
	'use_end_day' => null,
	'del_flg' => '0',
	'created' => '2022-11-01 15:50:57',
	'insert_user' => 'MG00000001',
	'modified' => '2023-11-27 10:25:13',
	'update_user' => 'AG01005104'
)
include - APP/View/CmpProducts/view.ctp, line 130
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

25103773

2022-11-01 00:00:00

2022-11-01 15:50:57

MG00000001

2023-11-27 10:25:13

AG01005104

View Edit Delete

New Farmer Product

(default) 3 queries took 283 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE `CmpProduct`.`id` = 17427	1	1	0
2	SELECT `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE `CmpProduct`.`id` = 17427 LIMIT 1	1	1	0
3	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`.`cmp_product_id` = (17427)	1	1	283

(default) 3 queries took 283 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE `CmpProduct`.`id` = 17427

SELECT `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE `CmpProduct`.`id` = 17427 LIMIT 1

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`.`cmp_product_id` = (17427)

283

Message	Memory use
Component initialization	3.56 MB
Controller action start	3.79 MB
Controller render start	5.85 MB
View render complete	7.29 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	17.39
Event: Controller.initialize	0.03
Event: Controller.startup	0.21
Controller action	294.70
Event: Controller.beforeRender	10.02
» Processing toolbar data	9.92
Rendering View	4.42
» Event: View.beforeRender	0.03
» Rendering APP/View/CmpProducts/view.ctp	2.97
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	0.79
» » Rendering CORE/Cake/View/Elements/sql_dump.ctp	0.20
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	aBRjheRnnMMWGlgCbOW-BgAAAkU
Redirect Redirect Kounotori Deploy Env	stg
Redirect Redirect Status	200
Redirect Unique Id	aBRjheRnnMMWGlgCbOW-BgAAAkU
Redirect Kounotori Deploy Env	stg
Redirect Status	200
Unique Id	aBRjheRnnMMWGlgCbOW-BgAAAkU
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
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	18.224.44.53
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	60849
Redirect Url	/app/webroot/cmp_products/view/17427
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/cmp_products/view/17427
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1746166661.3779
Request Time	1746166661

CakePHP: the rapid development php framework

Cmp Product

Actions

Related Farmer Products

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