Date - Flatpickr 1.7.26 Minimal theme
Manage date using the comprehensive Flat Pickr
HIDE CODE
SHOW CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("orders");
$xcrud->fields("orderDate,status,requiredDate,shippedDate,comments");
$xcrud->change_type("status","select","",array("Not Shipped"=>"Not Shipped","Shipped"=>"Shipped","Completed"=>"Completed"));
$xcrud->change_type("orderDate","flatpickr","","{enableTime:false,dateFormat:Y-m-d H:i:s,locale:it,altFormat:d-m-Y,altInput: true}");//"{enableTime:true,dateFormat:Y-m-d H:i:s,locale:it,altFormat:d-m-Y H:i:s,altInput: true}
$xcrud->change_type("requiredDate","flatpickr","",'{enableTime:false,dateFormat:Y-m-d H:i,locale:it,altFormat:d-m-Y,altInput: true}');
$xcrud->change_type("shippedDate","flatpickr","",'{enableTime:true,dateFormat:Y-m-d H:i,locale:it,altFormat:d-m-Y,altInput: true}');
echo $xcrud->render();
?>
Orders
Orders
# | Orderdate | Requireddate | Shippeddate | Status | Comments | Customernumber | |
1 | 2003-06-27 00:00:00 | 2003-07-04 00:00:00 | 2003-07-03 00:00:00 | Shipped | NULL | 141 | View Edit Remove |
2 | 2003-07-01 00:00:00 | 2003-07-10 00:00:00 | 2003-07-05 00:00:00 | Shipped | | 250 | View Edit Remove |
3 | 2003-07-02 00:00:00 | 2003-07-12 00:00:00 | 2003-07-03 00:00:00 | Shipped | NULL | 124 | View Edit Remove |
4 | 2003-07-04 00:00:00 | 2003-07-14 00:00:00 | 2003-07-06 00:00:00 | Shipped | Customer is interested in buying more Ferrari
| 242 | View Edit Remove |
5 | 2003-07-10 00:00:00 | 2003-07-20 00:00:00 | 2024-05-15 00:00:00 | Shipped | PROVA | 353 | View Edit Remove |
6 | 2003-07-07 00:00:00 | 2003-07-16 00:00:00 | 2003-07-13 00:00:00 | Shipped | | 496 | View Edit Remove |
7 | 2003-07-16 00:00:00 | 2003-07-23 00:00:00 | 2003-07-21 00:00:00 | Shipped | | 282 | View Edit Remove |
8 | 2003-07-24 00:00:00 | 2003-08-02 00:00:00 | 2003-07-30 00:00:00 | Shipped | | 161 | View Edit Remove |
9 | 2003-08-01 00:00:00 | 2003-08-09 00:00:00 | 2003-08-04 00:00:00 | Shipped | | 334 | View Edit Remove |
10 | 2003-08-08 00:00:00 | 2003-08-16 00:00:00 | 2003-08-13 00:00:00 | Shipped | | 124 | View Edit Remove |