( ! ) Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/html/plugins/sendmail/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 69
Call Stack
#TimeMemoryFunctionLocation
10.0014453984{main}( ).../yoshinoya-.php:0
20.0238851032PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setTitle( $title = 'DATA INBOUND', $updateFormulaCellReferences = ???, $validate = ??? ).../yoshinoya-.php:37
30.0238851032PhpOffice\PhpSpreadsheet\ReferenceHelper->updateNamedFormulas( $spreadsheet = class PhpOffice\PhpSpreadsheet\Spreadsheet { private $uniqueID = '6a519530afa764.26498031'; private $properties = class PhpOffice\PhpSpreadsheet\Document\Properties { private $creator = 'Unknown Creator'; private $lastModifiedBy = 'Unknown Creator'; private $created = 1783731504; private $modified = 1783731504; private $title = 'Untitled Spreadsheet'; private $description = ''; private $subject = ''; private $keywords = ''; private $category = ''; private $manager = ''; private $company = ''; private $customProperties = [...] }; private $security = class PhpOffice\PhpSpreadsheet\Document\Security { private $lockRevision = FALSE; private $lockStructure = FALSE; private $lockWindows = FALSE; private $revisionsPassword = ''; private $workbookPassword = '' }; private $workSheetCollection = [0 => class PhpOffice\PhpSpreadsheet\Worksheet\Worksheet { ... }]; private $calculationEngine = class PhpOffice\PhpSpreadsheet\Calculation\Calculation { private $spreadsheet = ...; private $calculationCache = [...]; private $calculationCacheEnabled = TRUE; private $branchStoreKeyCounter = 0; private $branchPruningEnabled = TRUE; private $debugLog = class PhpOffice\PhpSpreadsheet\Calculation\Engine\Logger { ... }; public $suppressFormulaErrors = FALSE; public $formulaError = NULL; private $cyclicReferenceStack = class PhpOffice\PhpSpreadsheet\Calculation\Engine\CyclicReferenceStack { ... }; private $cellStack = [...]; private $cyclicFormulaCounter = 1; private $cyclicFormulaCell = ''; public $cyclicFormulaCount = 1; private $delta = 1.0E-14 }; private $activeSheetIndex = 0; private $definedNames = []; private $cellXfSupervisor = class PhpOffice\PhpSpreadsheet\Style\Style { protected $isSupervisor = TRUE; protected $parent = ...; protected $parentPropertyName = NULL; protected $font = class PhpOffice\PhpSpreadsheet\Style\Font { ... }; protected $fill = class PhpOffice\PhpSpreadsheet\Style\Fill { ... }; protected $borders = class PhpOffice\PhpSpreadsheet\Style\Borders { ... }; protected $alignment = class PhpOffice\PhpSpreadsheet\Style\Alignment { ... }; protected $numberFormat = class PhpOffice\PhpSpreadsheet\Style\NumberFormat { ... }; protected $protection = class PhpOffice\PhpSpreadsheet\Style\Protection { ... }; protected $index = NULL; protected $quotePrefix = FALSE }; private $cellXfCollection = [0 => class PhpOffice\PhpSpreadsheet\Style\Style { ... }]; private $cellStyleXfCollection = [0 => class PhpOffice\PhpSpreadsheet\Style\Style { ... }]; private $hasMacros = FALSE; private $macrosCode = NULL; private $macrosCertificate = NULL; private $ribbonXMLData = NULL; private $ribbonBinObjects = NULL; private $unparsedLoadedData = []; private $showHorizontalScroll = TRUE; private $showVerticalScroll = TRUE; private $showSheetTabs = TRUE; private $minimized = FALSE; private $autoFilterDateGrouping = TRUE; private $firstSheetIndex = 0; private $visibility = 'visible'; private $tabRatio = 600 }, $oldName = 'Worksheet', $newName = 'DATA INBOUND' ).../Worksheet.php:892
40.0238851032PhpOffice\PhpSpreadsheet\Spreadsheet->getWorksheetIterator( ).../ReferenceHelper.php:937
50.0238851032Composer\Autoload\ClassLoader->loadClass( $class = 'PhpOffice\\PhpSpreadsheet\\Worksheet\\Iterator' ).../Spreadsheet.php:1099
60.0238851192Composer\Autoload\{closure:/var/www/html/plugins/sendmail/vendor/composer/ClassLoader.php:575-577}( $file = '/var/www/html/plugins/sendmail/vendor/composer/../phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php' ).../ClassLoader.php:427
70.0238851592include( '/var/www/html/plugins/sendmail/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php ).../ClassLoader.php:576
( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.r.po_number' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/yoshinoya-.php on line 109
( ! ) mysqli_sql_exception: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.r.po_number' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/yoshinoya-.php on line 109
Call Stack
#TimeMemoryFunctionLocation
10.0014453984{main}( ).../yoshinoya-.php:0
20.0249884320query( $query = '\r\nSELECT \r\n r.nota kode_sj,\r\n r.po_number,\r\n r.received_at tanggal_diterima,\r\n p.sku_number kode_sku,\r\n p.boxContain uom,\r\n p.name AS product_name,\r\n COUNT(*) qty,\r\n CASE \r\n WHEN i.status = \'stored\' THEN \'Tersimpan\'\r\n WHEN i.status = \'uncome\' THEN \'Tidak Datang\'\r\n WHEN i.status = \'rejected\' THEN \'Ditolak\'\r\n ELSE i.status\r\n END AS translated_status,\r\n CASE \r\n WHEN i.date_expired IS NULL THEN \'N/A\' \r\n ELSE i.date_expired \r\n END AS date'... ).../yoshinoya-.php:109