Ejemplo n.º 1
0
function formcraft_basic_get_submissions()
{
    global $fcb_meta, $forms_table, $submissions_table, $wpdb;
    if (!current_user_can($fcb_meta['user_can'])) {
        die;
    }
    $page = isset($_POST['page']) && ctype_digit($_POST['page']) ? $_POST['page'] - 1 : 0;
    $form = isset($_POST['form']) && ctype_digit($_POST['form']) ? $_POST['form'] : 0;
    $per_page = 10;
    $from = $page * $per_page;
    $to = $from + $per_page;
    if ($form == 0) {
        $submissions = $wpdb->get_results("SELECT id,form,form_name,created FROM {$submissions_table} ORDER BY created DESC LIMIT {$from}, {$per_page}", ARRAY_A);
        $total = $wpdb->get_var("SELECT COUNT(*) FROM {$submissions_table}");
    } else {
        $submissions = $wpdb->get_results("SELECT id,form,form_name,created FROM {$submissions_table} WHERE form = {$form} ORDER BY created DESC LIMIT {$from}, {$to}", ARRAY_A);
        $total = $wpdb->get_var("SELECT COUNT(*) FROM {$submissions_table} WHERE form = {$form}");
    }
    if (is_array($submissions) && count($submissions) > 0) {
        foreach ($submissions as $key => $value) {
            $submissions[$key]['created'] = fcb_time_ago(strtotime(current_time('mysql')) - strtotime($submissions[$key]['created']));
        }
        echo json_encode(array('pages' => ceil($total / $per_page), 'submissions' => $submissions, 'total' => $total));
        die;
    } else {
        echo json_encode(array('pages' => '0', 'total' => '0'));
        die;
    }
}
Ejemplo n.º 2
0
'><?php 
        echo $value->name;
        ?>
</a></span>
									<span style='width:10%'><a href='admin.php?page=formcraft_basic_dashboard&id=<?php 
        echo $value->id;
        ?>
'><?php 
        echo $form_views;
        ?>
</a></span>
									<span style='width:30%'><a href='admin.php?page=formcraft_basic_dashboard&id=<?php 
        echo $value->id;
        ?>
'><?php 
        echo fcb_time_ago(strtotime(current_time('mysql')) - strtotime($value->modified));
        ?>
</a></span>
									<span style='width:10%'><i data-id='<?php 
        echo $value->id;
        ?>
' class='trash-icon trash-form icon-trash-1'></i></span>
								</div>
								<?php 
    }
} else {
    ?>
							<span class='no-subs-content' data-toggle="fcbmodal" data-target="#new_form_modal"><?php 
    _e('Create New Form', 'formcraft_basic');
    ?>
</span>