Input - Autocomplete 1.7.26 Default theme
Manage date using the comprehensive Flat Pickr
HIDE CODE
<?php
$xcrud = Xcrud::get_instance();
$xcrud->table("payments");
$xcrud->set_attr("checkNumber",array("list"=>"europe-countries"));
echo $xcrud->render();
?>
<datalist id="europe-countries">
<option>Russia</option>
<option>Germany</option>
<option>United Kingdom</option>
</datalist>
<?php
/*
* Xcrud Configuration for Input Mask
*
* This section configures the Xcrud instance and applies input masks to fields
* using the Inputmask plugin. Below is a list of commonly used input mask formats.
*
* Usage:
* - Set the "data-inputmask" attribute with the desired mask pattern.
*
* Example:
* $xcrud->set_attr("field_name", array("data-inputmask" => "'mask': 'pattern'"));
*
* Commonly Used Input Mask Formats:
*
* 1. Phone Number
* - Format: (123) 456-7890
* - Mask: '999 999-9999'
* - Example:
* $xcrud->set_attr("phoneNumber", array("data-inputmask" => "'mask': '(999) 999-9999'"));
*
* 2. Date (MM/DD/YYYY)
* - Format: 12/31/2024
* - Mask: '99/99/9999'
* - Example:
* $xcrud->set_attr("dateOfBirth", array("data-inputmask" => "'mask': '99/99/9999'"));
*
* 3. Social Security Number (SSN)
* - Format: 123-45-6789
* - Mask: '999-99-9999'
* - Example:
* $xcrud->set_attr("ssn", array("data-inputmask" => "'mask': '999-99-9999'"));
*
* 4. Zip Code (US)
* - Format: 12345 or 12345-6789
* - Mask: '99999[-9999]'
* - Example:
* $xcrud->set_attr("zipCode", array("data-inputmask" => "'mask': '99999[-9999]'"));
*
* 5. Credit Card Number
* - Format: 1234 5678 9012 3456
* - Mask: '9999 9999 9999 9999'
* - Example:
* $xcrud->set_attr("creditCard", array("data-inputmask" => "'mask': '9999 9999 9999 9999'"));
*
* 6. Currency
* - Format: $1,234.56
* - Mask: '$9999.99'
* - Example:
* $xcrud->set_attr("amount", array("data-inputmask" => "'mask': '$9999.99'"));
*
* 7. Time (24-Hour Format)
* - Format: 14:30
* - Mask: '99:99'
* - Example:
* $xcrud->set_attr("time", array("data-inputmask" => "'mask': '99:99'"));
*
* 8. Custom Alphanumeric
* - Format: AB-12345
* - Mask: 'AA-99999'
* - Example:
* $xcrud->set_attr("customField", array("data-inputmask" => "'mask': 'AA-99999'"));
*/
?>
Payments
Add Export into CSV Print Search
| # | Customernumber | Checknumber | Paymentdate | Amount | |
|---|---|---|---|---|---|
| 1 | 141 | bolo | 15.07.2004 00:00:00 | 2.3456789034567896e97 | View Edit Remove |
| 2 | 146 | FP549817 | 18.03.2004 00:00:00 | 56 | View Edit Remove |
| 3 | 146 | FU793410 | 16.01.2004 00:00:00 | 2.3456789034567896e97 | View Edit Remove |
| 4 | 298 | LJ160635 | 10.12.2003 00:00:00 | 30000 | View Edit Remove |
| 5 | 148899 | BI507030 | 22.04.2003 00:00:00 | 44380.15 | View Edit Remove |
| 6 | 148 | DD635282 | 11.08.2004 00:00:00 | 2611.84 | View Edit Remove |
| 7 | 148 | ME497970 | 27.03.2005 00:00:00 | 3516.04 | View Edit Remove |
| 8 | 151 | BF686658 | 27.12.2003 00:00:00 | 2.3456789034567896e97 | View Edit Remove |
| 9 | 151 | GB852215 | 26.07.2004 00:00:00 | 20314.44 | View Edit Remove |
| 10 | 151 | KI884577 | 14.12.2004 00:00:00 | 39964.63 | View Edit Remove |
?>