phpGrid(v6.1) {jqGrid:v4.5.2, jQuery:v1.9.0, jQuery UI:1.10.0}
AJAX RESPONSE
CONTROL VALIDATION
DATAGRID OBJECT
C_DataGrid Object
(
[jq_colModel] => Array
(
[0] => Array
(
[name] => record_id
[index] => record_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[1] => Array
(
[name] => record_date
[index] => record_date
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[dataInit] => ###function(el){$(el).datepicker({changeMonth: true, changeYear: true,dateFormat:'yy-mm-dd'});}###
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[date] => 1
)
)
[2] => Array
(
[name] => organization_id
[index] => organization_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[3] => Array
(
[name] => indicator_id
[index] => indicator_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[4] => Array
(
[name] => res_value
[index] => res_value
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[5] => Array
(
[name] => organization_name
[index] => organization_name
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[6] => Array
(
[name] => indicatorcategory_id
[index] => indicatorcategory_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[7] => Array
(
[name] => indicatorsubcategory_id
[index] => indicatorsubcategory_id
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
[number] => 1
)
)
[8] => Array
(
[name] => indicator_name
[index] => indicator_name
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[9] => Array
(
[name] => indicatorcategory_name
[index] => indicatorcategory_name
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
[10] => Array
(
[name] => indicatorsubcategory_name
[index] => indicatorsubcategory_name
[hidden] =>
[edittype] => text
[editable] =>
[editoptions] => Array
(
[size] => 30
)
[editrules] => Array
(
[edithidden] =>
[required] =>
)
)
)
[before_script_end] =>
[sql:C_DataGrid:private] => SELECT t1.record_id,t1.record_date,t1.organization_id,t1.indicator_id,t1.res_value,t2.organization_name,t3.indicatorcategory_id,t3.indicatorsubcategory_id,t3.indicator_name,t4.indicatorcategory_name,t5.indicatorcategory_name AS indicatorsubcategory_name FROM records t1 INNER JOIN organizations t2 ON t1.organization_id=t2.organization_id INNER JOIN indicators t3 ON t1.indicator_id=t3.indicator_id INNER JOIN indicatorscategories t4 ON t3.indicatorcategory_id=t4.indicatorcategory_id INNER JOIN indicatorscategories t5 ON t3.indicatorsubcategory_id=t5.indicatorcategory_id
[scSszsDyqcqvyLtAFSSN:C_DataGrid:private] =>
[zrXrgBcJRXotwTescYJA:C_DataGrid:private] => Array
(
[0] => record_id
)
[eaIqmgLgnItFsoWAEdnn:C_DataGrid:private] =>
[hsYgbsoKPwcvUUbPQzPB:C_DataGrid:private] => Array
(
)
[pVawonXnNSHaEXaDfFHI:C_DataGrid:private] => Array
(
)
[zvafcTTQXCrTldoMphnk:C_DataGrid:private] => Array
(
)
[SACPlesooIgyQwzUvygD:C_DataGrid:private] => Array
(
)
[PANnnZOkwjpmkOkVvVwC:C_DataGrid:private] => Array
(
)
[UOhOtcBpeAFtRyciFDDy:C_DataGrid:private] => Array
(
)
[RoUowslhIdwEIaInViMf:C_DataGrid:private] => Array
(
)
[XIBGEbyMabbfmxNHrxXx:C_DataGrid:private] => Array
(
)
[fUcwMLVOIobtdZjLtYtg:C_DataGrid:private] =>
[MQJXbVXNRTXanHMYJacp:C_DataGrid:private] => Array
(
)
[col_custom:C_DataGrid:private] =>
[col_custom_css:C_DataGrid:private] =>
[col_wysiwyg:C_DataGrid:private] => Array
(
)
[col_default:C_DataGrid:private] => Array
(
)
[col_frozen:C_DataGrid:private] => Array
(
)
[iLvxWIxnUzJrEhpjrao:C_DataGrid:private] => Array
(
)
[col_aligns:C_DataGrid:private] => Array
(
)
[col_edit_dimension:C_DataGrid:private] => Array
(
)
[col_fileupload:C_DataGrid:private] => Array
(
)
[col_virtual:C_DataGrid:private] => Array
(
)
[col_customrule:C_DataGrid:private] => Array
(
)
[col_autocomplete:C_DataGrid:private] => Array
(
)
[sql_filter:C_DataGrid:private] =>
[XcxAhvGrghbgRhQjASCk:C_DataGrid:private] => Array
(
)
[HiDeeAQGDLlArSxADilW:C_DataGrid:private] =>
[uafWxTshdmADXTMDTklI:C_DataGrid:private] =>
[KTlAoREvwiABqfDJVNEw:C_DataGrid:private] => list1
[OBdYQDhAdXqrTqVMLXyb:C_DataGrid:private] => "/platform3/phpgrid/data.php?dt=json&gn=list1"
[ULeutgFTmojSwEYDKora:C_DataGrid:private] => json
[nvfTJfEVtLSTDFHxmGdO:C_DataGrid:private] => GET
[EGokLNhbxsytTlNLuek:C_DataGrid:private] => Array
(
[0] => record_id
[1] => record_date
[2] => organization_id
[3] => indicator_id
[4] => res_value
[5] => organization_name
[6] => indicatorcategory_id
[7] => indicatorsubcategory_id
[8] => indicator_name
[9] => indicatorcategory_name
[10] => indicatorsubcategory_name
)
[UOyOGKiRwfFitEOKaDJg:C_DataGrid:private] => "#list1_pager1"
[MmoDPgJDqiHLGduvILCl:C_DataGrid:private] => 20
[zutaWmUZBdGUnnsHgZMX:C_DataGrid:private] => Array
(
[0] => 10
[1] => 20
[2] => 30
[3] => 50
[4] => 100
)
[uRCwctSIiIQCRgDGpcne:C_DataGrid:private] =>
[vRWAzQRwIXUwFkpzVjxw:C_DataGrid:private] => ASC
[JsbbcbmspLiBhqINTbUk:C_DataGrid:private] => 1
[yGYEtEnxhjjKkhgYHNDY:C_DataGrid:private] =>
[KRDXLIBrFRHCoeSOqjkA:C_DataGrid:private] => 1
[xuQFNnhvcyHtqnGcBhMG:C_DataGrid:private] => 1000
[GJJDFKJuwbvUepXRNCmw:C_DataGrid:private] => 100%
[jEJekHnIUYJyXZFMfWGx:C_DataGrid:private] =>
[cXrNZkDGJCpCjSjwZbTO:C_DataGrid:private] =>
[jq_group_summary_show:C_DataGrid:private] =>
[jq_direction:C_DataGrid:private] => ltr
[zHRNpIMrDVAgrQsvVtZE:C_DataGrid:private] => false
[zmVukhkanNsqMLAgNHo:C_DataGrid:private] =>
[QLEPwSsWCvOjPDcRTbFo:C_DataGrid:private] =>
[MwLBVGpewctwYSzPznkm:C_DataGrid:private] => 1
[vZcbjVPOYxEYkSeDHXxE:C_DataGrid:private] => 22
[OlSUUmiesJldiNOcVbEw:C_DataGrid:private] =>
[LmsrUIXSpQotFugJMyyw:C_DataGrid:private] =>
[ANSonKeeYyNtCvcWYFGw:C_DataGrid:private] =>
[wUjfgQlaWGldXCojLeoG:C_DataGrid:private] => Loading phpGrid Lite...
[eoFwRjfefzfopfXkQgE:C_DataGrid:private] =>
[MnPIiIfPbTYyGDsWpmLc:C_DataGrid:private] =>
[JSPfsgttAJEyMQrsZiqu:C_DataGrid:private] => 1
[sWVCTvNSQeMPkSkdEAsV:C_DataGrid:private] => Array
(
[is_resizable] =>
[min_width] => 300
[min_height] => 100
)
[idggOwYvEktONuEdoPoK:C_DataGrid:private] => 41
[_num_fields:C_DataGrid:private] => 11
[BQAYLNvLQdSuZPEhnuKm:C_DataGrid:private] => phpGrid(v6.1) {jqGrid:v4.5.2, jQuery:v1.9.0, jQuery UI:1.10.0}
[MztodXfJgEiCmKNScggI:C_DataGrid:private] => 450
[cFgBYpzYPivTwUZtqspi:C_DataGrid:private] => 100%
[edit_mode:C_DataGrid:private] => NONE
[jSlnDHdHaQtmqMFOEynQ:C_DataGrid:private] =>
[ohaoHLBeaYiXgPPJlnbX:C_DataGrid:private] =>
[advanced_search:C_DataGrid:private] => 1
[QsgAuJpMPrCveLqQnfKa:C_DataGrid:private] =>
[hwVTcgcSWcxkcCOEhJk:C_DataGrid:private] => Array
(
[hover] => #F2FC9C
[highlight] => yellow
[altrow] => #F5FAFF
)
[WLCxhqvYPTTeDtasSuUU:C_DataGrid:private] => start
[DgOKQsyjASLDMkpkbTHk:C_DataGrid:private] => en
[auto_resize:C_DataGrid:private] =>
[wRjrMkifPQphcoKIsOId:C_DataGrid:private] =>
[export_type] => EXCEL
[oIDYHZWuwSBAAxdLqWIs] => /platform3/phpgrid/export.php?dt=json&gn=list1
[debug] => 1
[db] => C_Database Object
(
[zyKIxGFCDaGuObCtPLcH] => localhost
[LYZymBHAGWBWWOZHXICM] => waspmote
[password] => qwe#123!@#
[databaseName] => waspmote
[tableName] =>
[link] =>
[dbType] => mysql
[charset] => utf8
[db] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => waspmote
[host] => localhost
[user] => waspmote
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => 1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 11
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 1897513 Threads: 3 Questions: 697542 Slow queries: 621 Opens: 127 Flush tables: 1 Open tables: 120 Queries per second avg: 0.367
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 77159
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 2
[1] => 10
[2] => 1
[3] => 1
[4] => 5
[5] => 27
[6] => 1
[7] => 1
[8] => 47
[9] => 18
[10] => 39
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => waspmote
)
[result] => ADORecordSet_mysqli Object
(
[databaseType] => mysqli
[canSeek] => 1
[dataProvider] => native
[fields] => Array
(
[0] => 15
[record_id] => 15
[1] => 2020-03-03
[record_date] => 2020-03-03
[2] => 1
[organization_id] => 1
[3] => 5
[indicator_id] => 5
[4] => 50.00
[res_value] => 50.00
[5] => Δήμος Αθηναίων
[organization_name] => Δήμος Αθηναίων
[6] => 1
[indicatorcategory_id] => 1
[7] => 2
[indicatorsubcategory_id] => 2
[8] => Ποσοστό ανεργίας των νέων
[indicator_name] => Ποσοστό ανεργίας των νέων
[9] => Οικονομία
[indicatorcategory_name] => Οικονομία
[10] => Οικονομία-απασχόληση
[indicatorsubcategory_name] => Οικονομία-απασχόληση
)
[blobSize] => 100
[sql] => SELECT t1.record_id,t1.record_date,t1.organization_id,t1.indicator_id,t1.res_value,t2.organization_name,t3.indicatorcategory_id,t3.indicatorsubcategory_id,t3.indicator_name,t4.indicatorcategory_name,t5.indicatorcategory_name AS indicatorsubcategory_name FROM records t1 INNER JOIN organizations t2 ON t1.organization_id=t2.organization_id INNER JOIN indicators t3 ON t1.indicator_id=t3.indicator_id INNER JOIN indicatorscategories t4 ON t3.indicatorcategory_id=t4.indicatorcategory_id INNER JOIN indicatorscategories t5 ON t3.indicatorsubcategory_id=t5.indicatorcategory_id LIMIT 1,1
[EOF] =>
[emptyTimeStamp] =>
[emptyDate] =>
[debug] =>
[timeCreated] => 0
[bind] =>
[fetchMode] => 3
[connection] => ADODB_mysqli Object
(
[databaseType] => mysqli
[dataProvider] => mysql
[hasInsertID] => 1
[hasAffectedRows] => 1
[metaTablesSQL] => SELECT
TABLE_NAME,
CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA=
[metaColumnsSQL] => SHOW COLUMNS FROM `%s`
[fmtTimeStamp] => 'Y-m-d H:i:s'
[hasLimit] => 1
[hasMoveFirst] => 1
[hasGenID] => 1
[isoDates] => 1
[sysDate] => CURDATE()
[sysTimeStamp] => NOW()
[hasTransactions] => 1
[forceNewConnect] =>
[poorAffectedRows] => 1
[clientFlags] => 0
[substr] => substring
[port] => 3306
[socket] =>
[_bindInputArray] =>
[nameQuote] => `
[optionFlags] => Array
(
[0] => Array
(
[0] => 5
[1] => 0
)
)
[arrayClass] => ADORecordSet_array_mysqli
[multiQuery] =>
[_genIDSQL] => update %s set id=LAST_INSERT_ID(id+1);
[_genSeqSQL] => create table if not exists %s (id int not null)
[_genSeqCountSQL] => select count(*) from %s
[_genSeq2SQL] => insert into %s values (%s)
[_dropSeqSQL] => drop table if exists %s
[database] => waspmote
[host] => localhost
[user] => waspmote
[password] => not stored
[debug] =>
[maxblobsize] => 262144
[concat_operator] => +
[length] => length
[random] => rand()
[upperCase] => upper
[fmtDate] => 'Y-m-d'
[true] => 1
[false] => 0
[replaceQuote] => \'
[charSet] =>
[metaDatabasesSQL] =>
[uniqueOrderBy] =>
[emptyDate] =>
[emptyTimeStamp] =>
[lastInsID] =>
[hasTop] =>
[readOnly] =>
[genID] => 0
[raiseErrorFn] =>
[cacheSecs] => 3600
[memCache] =>
[memCacheHost] =>
[memCachePort] => 11211
[memCacheCompress] =>
[sysUTimeStamp] =>
[noNullStrings] =>
[numCacheHits] => 0
[numCacheMisses] => 0
[pageExecuteCountRows] => 1
[uniqueSort] =>
[leftOuter] =>
[rightOuter] =>
[ansiOuter] =>
[autoRollback] =>
[fnExecute] =>
[fnCacheExecute] =>
[blobEncodeType] =>
[rsPrefix] => ADORecordSet_
[autoCommit] => 1
[transOff] => 0
[transCnt] => 0
[fetchMode] => 3
[null2null] => null
[bulkBind] =>
[_oldRaiseFn] =>
[_transOK] =>
[_connectionID] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $
[client_version] => 50011
[connect_errno] => 0
[connect_error] =>
[errno] => 0
[error] =>
[error_list] => Array
(
)
[field_count] => 11
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.6.46
[server_version] => 50646
[stat] => Uptime: 1897513 Threads: 3 Questions: 697543 Slow queries: 621 Opens: 127 Flush tables: 1 Open tables: 120 Queries per second avg: 0.367
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 77159
[warning_count] => 0
)
[_errorMsg] =>
[_errorCode] =>
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 2
[1] => 10
[2] => 1
[3] => 1
[4] => 5
[5] => 27
[6] => 1
[7] => 1
[8] => 47
[9] => 18
[10] => 39
)
[num_rows] => 1
[type] => 0
)
[_isPersistentConnection] =>
[_evalAll] =>
[_affected] =>
[_logsql] =>
[_transmode] =>
[connectionParameters:protected] => Array
(
)
[databaseName] => waspmote
)
[_numOfRows] => 1
[_numOfFields] => 11
[_queryID] => mysqli_result Object
(
[current_field] => 11
[field_count] => 11
[lengths] => Array
(
[0] => 2
[1] => 10
[2] => 1
[3] => 1
[4] => 5
[5] => 27
[6] => 1
[7] => 1
[8] => 47
[9] => 18
[10] => 39
)
[num_rows] => 1
[type] => 0
)
[_currentRow] => 0
[_closed] =>
[_inited] => 1
[_obj] =>
[_names] =>
[_currentPage] => -1
[_atFirstPage] =>
[_atLastPage] =>
[_lastPageNo] => -1
[_maxRecordCount] => 0
[datetime] =>
[adodbFetchMode] => 3
)
)
[db_connection] => Array
(
)
[xAalFtwJwMQLkdTRRULE] =>
[obj_md] =>
[data_local] => Array
(
)
[jq_rowConditions:C_DataGrid:private] => Array
(
)
[jq_cellConditions:C_DataGrid:private] => Array
(
)
[script_includeonce:C_DataGrid:private] =>
[script_body:C_DataGrid:private] =>
[script_editEvtHandler:C_DataGrid:private] =>
[hAQEPLwsYfgQOCngLkto:C_DataGrid:private] =>
[cust_col_properties:C_DataGrid:private] => Array
(
)
[cust_grid_properties:C_DataGrid:private] => Array
(
)
[cust_prop_jsonstr] =>
[DDcSdMlljylessezxSly:C_DataGrid:private] =>
[grid_methods:C_DataGrid:private] => Array
(
)
[edit_file:C_DataGrid:private] => edit.php
[col_formats] => Array
(
)
[jq_shrinkToFit] => 1
[jq_is_group_summary] =>
)
SESSION OBJECT
SESSION NAME: PHPSESSID
SESSION ID: e2v0mupk45ta9690c7hmnp0mf5
SESSION KEY: _oPHPGRID_list1
{
"_oPHPGRID_list1_sql":"SELECT t1.record_id,t1.record_date,t1.organization_id,t1.indicator_id,t1.res_value,t2.organization_name,t3.indicatorcategory_id,t3.indicatorsubcategory_id,t3.indicator_name,t4.indicatorcategory_name,t5.indicatorcategory_name AS indicatorsubcategory_name FROM records t1 INNER JOIN organizations t2 ON t1.organization_id=t2.organization_id INNER JOIN indicators t3 ON t1.indicator_id=t3.indicator_id INNER JOIN indicatorscategories t4 ON t3.indicatorcategory_id=t4.indicatorcategory_id INNER JOIN indicatorscategories t5 ON t3.indicatorsubcategory_id=t5.indicatorcategory_id","_oPHPGRID_list1_sql_key":"a:1:{
i:0;s:9:\"record_id\";
}","_oPHPGRID_list1_sql_fkey":null,"_oPHPGRID_list1_sql_table":"","_oPHPGRID_list1_sql_filter":null,"_oPHPGRID_list1_db_connection":"a:0:{
}","_oPHPGRID_list1_has_multiselect":false,"_oPHPGRID_list1_export_type":"EXCEL","_oPHPGRID_list1_col_titles":"a:0:{
}","_oPHPGRID_list1_col_hiddens":"a:0:{
}"
}