Eigene Bestellungen nicht mehr sichtbar
ich seh als ecoenergy (person.seq_id 9) bei https://www.mygood.at/de/shop/myshop/myorders folgende Bestellung nicht (mehr), bitte wieder sichtbar machen, danke
ok, nach testen scheint es nicht an den Benutzerrechten zu liegen sondern an Fehlfunktionen in myorders:
- Sortierung ist nicht einstellbar, er zeigt leider alte Bestellungen zuerst an - bitte neue zuerst
- Datumseinschränkung verursacht:
ERROR TypeError: "this.fromDate.getTime is not a function"
getOrders https://www.mygood.at/18-es2015.d4a60df7670f2c250001.js:1
getOtherPage https://www.mygood.at/18-es2015.d4a60df7670f2c250001.js:1- Bestellungen pro Seite bitte bis 100 Stk
- Filtern nach "Neu" liefert nichts wenn man vorher auf Seiten > 1 war
- Filtern nach "Neu" frisch aufgerufen sortiert wirr
mysql> select username from person where seq_id=9;
+-----------+
| username |
+-----------+
| ecoenergy |
+-----------+
1 row in set (0.00 sec)
mysql>
mysql> select * from order_products where seq_id=883;
+--------+------------------------+-------------------+-----------------+------------------------+-------+----------+-----------------+---------+------------+-------------------------+-----------------+-----------+-----------------+
| seq_id | fperson_contact_seq_id | forderinfo_seq_id | fproduct_seq_id | forder_product_details | price | quantity | order_status_kz | subtype | unit_value | fperson_customer_seq_id | price_unit_time | price_tax | fvariant_seq_id |
+--------+------------------------+-------------------+-----------------+------------------------+-------+----------+-----------------+---------+------------+-------------------------+-----------------+-----------+-----------------+
| 883 | 9 | 534 | 145 | 606 | 2.99 | 1.000 | NEU | <null> | 0.750 | 263 | 0.00 | 20 | NULL |
+--------+------------------------+-------------------+-----------------+------------------------+-------+----------+-----------------+---------+------------+-------------------------+-----------------+-----------+-----------------+
1 row in set (0.00 sec)
mysql> select * from order_product_details where seq_id=606;
+--------+------------------------+-------------------+---------------------------------+--------------------+----------------+---------------------+--------------+----------------+----------------+-------------+---------------+-------------------------+---------------+--------------+--------------+--------------------------+---------------+-------------+--------------+-------------+-----------+---------------------+---------+
| seq_id | fperson_contact_seq_id | forderinfo_seq_id | fcollective_distribution_seq_id | distribution_price | selfservice_kz | sum_order_status_kz | receipt_date | receipt_repeat | receipt_number | cancel_date | cancel_repeat | fperson_customer_seq_id | order_type_kz | fwork_seq_id | buchungsinfo | RKSV_SERIENNR_ZERTIFIKAT | RKSV_SIGNATUR | RKSV_QRCODE | RKSV_ZAEHLER | RKSV_UMSATZ | updatedAt | createdAt | message |
+--------+------------------------+-------------------+---------------------------------+--------------------+----------------+---------------------+--------------+----------------+----------------+-------------+---------------+-------------------------+---------------+--------------+--------------+--------------------------+---------------+-------------+--------------+-------------+-----------+---------------------+---------+
| 606 | 9 | 534 | 36 | NULL | Y | NEU | NULL | NULL | NULL | NULL | NULL | 263 | S | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2019-11-17 19:47:38 | NULL |
+--------+------------------------+-------------------+---------------------------------+--------------------+----------------+---------------------+--------------+----------------+----------------+-------------+---------------+-------------------------+---------------+--------------+--------------+--------------------------+---------------+-------------+--------------+-------------+-----------+---------------------+---------+
1 row in set (0.00 sec)
mysql> select * from collective_distribution where seq_id=36;
+--------+-----------------------+------------------------+-----------------------+-----------------+-----------------------------------------+-----------+-----------+---------------+----------------+---------------+-------------+----------------+----------------+------------------+----------------------------+--------------------------+-----------------+------------+-----------------+---------------------+-----------+-----------+--------------------+---------+-----------------+----------------+---------+---------------------+
| seq_id | name | fperson_contact_seq_id | fcompany_plant_seq_id | deposit_percent | address | lat | lng | opening_hours | allproducts_kz | special_offer | bill_prefix | receipt_number | tax_number | uid_number | account_bank_name | account_number | account_bank_id | RKSV_AKTIV | fcd_main_seq_id | fpersongroup_seq_id | updatedAt | createdAt | deposit_regulation | version | collectiveOrder | collectiveBill | country | contact_email_cp_kz |
+--------+-----------------------+------------------------+-----------------------+-----------------+-----------------------------------------+-----------+-----------+---------------+----------------+---------------+-------------+----------------+----------------+------------------+----------------------------+--------------------------+-----------------+------------+-----------------+---------------------+-----------+-----------+--------------------+---------+-----------------+----------------+---------+---------------------+
| 36 | FoodCoop St. Ruprecht | 9 | 33 | 0.00 | Ossiach , 9570 Feldkirchen, Österreich | 46.677773 | 13.984446 | nach Anfrage | N | NULL | FOOD | 83 | StNr: 114/9547 | UID: ATU64953679 | Raiffeisenbank Gunskirchen | AT18 3412 9000 0006 6423 | 34129 | N | NULL | NULL | NULL | NULL | Keine | null | N | N | NULL | NULL |
+--------+-----------------------+------------------------+-----------------------+-----------------+-----------------------------------------+-----------+-----------+---------------+----------------+---------------+-------------+----------------+----------------+------------------+----------------------------+--------------------------+-----------------+------------+-----------------+---------------------+-----------+-----------+--------------------+---------+-----------------+----------------+---------+---------------------+
1 row in set (0.01 sec)
mysql> select fperson_contact_seq_id from company_plant where seq_id=33;
+------------------------+
| fperson_contact_seq_id |
+------------------------+
| 9 |
+------------------------+
1 row in set (0.00 sec)
mysql>