Date - Flatpickr NEW
Manage date using the comprehensive Flat Pickr
HIDE 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
# | Orderdate | Requireddate | Shippeddate | Status | Action | Comments | Customernumber | |
---|---|---|---|---|---|---|---|---|
1 | 2003-03-29 00:00:00 | 2003-03-19 15:48:41 | 2003-03-11 00:00:00 | Shipped | 0 | Customer requested that FedEx Ground is used for | 486 | View Edit Remove |
2 | 2003-03-18 00:00:00 | 2003-03-24 00:00:00 | 2003-03-20 00:00:00 | Shipped | 0 | 187 | View Edit Remove | |
3 | 2003-03-25 00:00:00 | 2003-03-31 00:00:00 | 2003-03-30 00:00:00 | Shipped | 0 | 129 | View Edit Remove | |
4 | 2003-03-24 00:00:00 | 2003-04-03 00:00:00 | 2003-03-29 00:00:00 | Shipped | 0 | Customer requested that ad materials (such as | 144 | View Edit Remove |
5 | 2003-03-26 00:00:00 | 2003-04-02 00:00:00 | 2003-03-27 00:00:00 | Shipped | 0 | 124 | View Edit Remove | |
6 | 2003-04-01 00:00:00 | 2003-04-24 00:00:00 | 2003-04-02 00:00:00 | Shipped | 0 | 172 | View Edit Remove | |
7 | 2003-04-04 00:00:00 | 2003-04-12 00:00:00 | 2003-04-07 00:00:00 | Shipped | 0 | 424 | View Edit Remove | |
8 | 2003-04-11 00:00:00 | 2003-04-19 00:00:00 | 2003-04-13 00:00:00 | Shipped | 0 | 381 | View Edit Remove | |
9 | 2003-04-16 00:00:00 | 2003-04-24 00:00:00 | 2003-04-17 00:00:00 | Shipped | 0 | 148 | View Edit Remove | |
10 | 2003-04-21 00:00:00 | 2003-04-29 00:00:00 | 2003-04-26 00:00:00 | Shipped | 0 | Customer has worked with some of our vendors in | 216 | View Edit Remove |