public static function update_punches($id = 0, $action = '')
{
if (!$id) {
return;
}
global $wpdb;
$table = $wpdb->prefix . "punch_cards";
$action = $_POST['action'];
$card_id = $_POST['card_id'];
echo json_encode(array('action' => $action, 'card_id' => $card_id, 'punches' => $punches, 'punches_html' => Punch_Card::get_punches_html($card_id, $punches)));
$punches = self::get_punch_card($id)->card_punches;
$punches = $action == "add" ? $punches + 1 : $punches - 1;
$wpdb->update($table, array('card_punches' => $punches), array('card_id' => $id));
return $punches;
}
/*
* DataTables server-side processing script for Subscriptions Tables.
*
*/
global $wpdb;
// DB table to use
$table = $wpdb->prefix . 'punch_cards';
// Table's primary key
$primaryKey = 'card_id';
// Array of database columns which should be read and sent back to DataTables.
// The `db` parameter represents the column name in the database, while the `dt`
// parameter represents the DataTables column identifier. In this case simple
// indexes
$columns = array(array('db' => 'card_id', 'dt' => 0, 'formatter' => function ($id) {
return sprintf('<span id="punch_card_%s">%s</span>', $id, $id);
}), array('db' => 'card_name', 'dt' => 1, 'formatter' => function ($id, $row) {
return sprintf('<a href="#TB_inline?&width=400&height200&inlineId=get-punch-card-meta" class="thickbox punch-card-meta" data-card_id="%d">%s</a>', $row[0], $id);
}), array('db' => 'card_email', 'dt' => 2), array('db' => 'card_phone', 'dt' => 3, 'formatter' => function ($phone) {
return Punch_Card::format_phone($phone);
}), array('db' => 'card_punches', 'dt' => 4, 'formatter' => function ($id, $row) {
return Punch_Card::get_punches_html($row[0], $id);
}), array('db' => 'card_completed', 'dt' => 5), array('db' => 'card_status', 'dt' => 6));
// SQL server connection information
$sql_details = array('user' => DB_USER, 'pass' => DB_PASSWORD, 'db' => DB_NAME, 'host' => DB_HOST);
/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* If you just want to use the basic configuration for DataTables with PHP
* server-side, there is no need to edit below this line.
*/
require 'ssp.class.php';
echo json_encode(SSP::simple($_GET, $sql_details, $table, $primaryKey, $columns));
die;