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] => appproblem_id [index] => appproblem_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [1] => Array ( [name] => origin [index] => origin [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [2] => Array ( [name] => cityzen_id [index] => cityzen_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [3] => Array ( [name] => organization_id [index] => organization_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [4] => Array ( [name] => code [index] => code [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [5] => Array ( [name] => image [index] => image [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [6] => Array ( [name] => description [index] => description [hidden] => [edittype] => textarea [editable] => [editoptions] => Array ( [cols] => 42 [rows] => 6 [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [7] => Array ( [name] => category_id [index] => category_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [8] => Array ( [name] => category_el [index] => category_el [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [9] => Array ( [name] => category_en [index] => category_en [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [10] => Array ( [name] => created_at [index] => created_at [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [11] => Array ( [name] => updated_at [index] => updated_at [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [12] => Array ( [name] => status_id [index] => status_id [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => [number] => 1 ) ) [13] => Array ( [name] => status_el [index] => status_el [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [14] => Array ( [name] => status_en [index] => status_en [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [15] => Array ( [name] => lat [index] => lat [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [16] => Array ( [name] => lng [index] => lng [hidden] => [edittype] => text [editable] => [editoptions] => Array ( [size] => 30 ) [editrules] => Array ( [edithidden] => [required] => ) ) [17] => Array ( [name] => date_insert [index] => date_insert [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] => ) ) ) [before_script_end] => [sql:C_DataGrid:private] => SELECT appproblem_id,origin,cityzen_id,organization_id,code,image,description,category_id,category_el,category_en,created_at,updated_at,status_id,status_el,status_en,lat,lng,date_insert FROM appproblems [scSszsDyqcqvyLtAFSSN:C_DataGrid:private] => [zrXrgBcJRXotwTescYJA:C_DataGrid:private] => Array ( [0] => appproblem_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] => appproblem_id [1] => origin [2] => cityzen_id [3] => organization_id [4] => code [5] => image [6] => description [7] => category_id [8] => category_el [9] => category_en [10] => created_at [11] => updated_at [12] => status_id [13] => status_el [14] => status_en [15] => lat [16] => lng [17] => date_insert ) [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] => 20 [_num_fields:C_DataGrid:private] => 18 [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] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.46 [server_version] => 50646 [stat] => Uptime: 1918473 Threads: 2 Questions: 708670 Slow queries: 642 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.369 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 78534 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 18 [field_count] => 18 [lengths] => Array ( [0] => 4 [1] => 3 [2] => 4 [3] => 1 [4] => 8 [5] => 0 [6] => 113 [7] => 3 [8] => 55 [9] => 33 [10] => 10 [11] => 10 [12] => 1 [13] => 36 [14] => 17 [15] => 10 [16] => 10 [17] => 19 ) [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] => 3022 [appproblem_id] => 3022 [1] => web [origin] => web [2] => 1168 [cityzen_id] => 1168 [3] => 2 [organization_id] => 2 [4] => 2020-816 [code] => 2020-816 [5] => [image] => [6] => Υπαρχει δρομος χωρις καθολου φωτισμο - τεστ παρακαλώ αγνοήστε [description] => Υπαρχει δρομος χωρις καθολου φωτισμο - τεστ παρακαλώ αγνοήστε [7] => 420 [category_id] => 420 [8] => Τοπoθέτηση Φωτιστικών Σωμάτων [category_el] => Τοπoθέτηση Φωτιστικών Σωμάτων [9] => Installation of Lighting Fixtures [category_en] => Installation of Lighting Fixtures [10] => 1586873459 [created_at] => 1586873459 [11] => 1587625580 [updated_at] => 1587625580 [12] => 7 [status_id] => 7 [13] => Έχει υποβληθεί ξανά [status_el] => Έχει υποβληθεί ξανά [14] => Already Submitted [status_en] => Already Submitted [15] => 35.3252902 [lat] => 35.3252902 [16] => 25.1387045 [lng] => 25.1387045 [17] => 2020-08-13 08:38:20 [date_insert] => 2020-08-13 08:38:20 ) [blobSize] => 100 [sql] => SELECT appproblem_id,origin,cityzen_id,organization_id,code,image,description,category_id,category_el,category_en,created_at,updated_at,status_id,status_el,status_en,lat,lng,date_insert FROM appproblems 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] => 18 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.6.46 [server_version] => 50646 [stat] => Uptime: 1918473 Threads: 2 Questions: 708671 Slow queries: 642 Opens: 129 Flush tables: 1 Open tables: 122 Queries per second avg: 0.369 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 78534 [warning_count] => 0 ) [_errorMsg] => [_errorCode] => [_queryID] => mysqli_result Object ( [current_field] => 18 [field_count] => 18 [lengths] => Array ( [0] => 4 [1] => 3 [2] => 4 [3] => 1 [4] => 8 [5] => 0 [6] => 113 [7] => 3 [8] => 55 [9] => 33 [10] => 10 [11] => 10 [12] => 1 [13] => 36 [14] => 17 [15] => 10 [16] => 10 [17] => 19 ) [num_rows] => 1 [type] => 0 ) [_isPersistentConnection] => [_evalAll] => [_affected] => [_logsql] => [_transmode] => [connectionParameters:protected] => Array ( ) [databaseName] => waspmote ) [_numOfRows] => 1 [_numOfFields] => 18 [_queryID] => mysqli_result Object ( [current_field] => 18 [field_count] => 18 [lengths] => Array ( [0] => 4 [1] => 3 [2] => 4 [3] => 1 [4] => 8 [5] => 0 [6] => 113 [7] => 3 [8] => 55 [9] => 33 [10] => 10 [11] => 10 [12] => 1 [13] => 36 [14] => 17 [15] => 10 [16] => 10 [17] => 19 ) [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: n76u7nrn8tt0sftsdlq5auns96
SESSION KEY: _oPHPGRID_list1
{ "_oPHPGRID_list1_sql":"SELECT appproblem_id,origin,cityzen_id,organization_id,code,image,description,category_id,category_el,category_en,created_at,updated_at,status_id,status_el,status_en,lat,lng,date_insert FROM appproblems","_oPHPGRID_list1_sql_key":"a:1:{ i:0;s:13:\"appproblem_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:{ }" }