Codeigniter:如何使用jQuery添加一个带有复选框的列,用于多选和删除


Codeigniter: How do I add a column with checkboxes for multiple select and delete using jQuery

我遇到了一个问题,在中我需要复选框来删除多个候选者,而不是单独删除它们。我正在使用代码点火器和数据表(jQuery)

    <?php echo $this->table->generate(); ?>

这就是它在视图中的加载方式。下面我将放置我的控制器:

    public function index ()
    {
        // Fetch all users
        // $this->data['tasks'] = $this->task_m->get();
        //datatable
        $tmpl = array ( 'table_open'  => '<table id="big_table" border="1" cellpadding="2" cellspacing="1" class="table ">' );
        $this->table->set_template($tmpl); 
        $this->table->set_heading('Select','Client Name','Subject','Booking Date','Status','Actions');
        // Load view
        $this->data['subview'] = 'admin/task/index';
        $this->load->view('admin/_layout_main', $this->data);
    }

下面是我的型号:

    public function list_tasks(){
    $userID = $this->session->userdata('id');
   $this->datatables->select("ci_customer.firstname,ci_task.subject_desc, ( DATE_FORMAT ( ci_task.booking_date ,('%d/%m/%Y
    '))), IFNULL( ( select c.pinged_status from ci_task_revisions c where c.task_id = ci_task.task_id order by revision_id desc limit 1 ), (ci_task.status) ) as status, ci_task.task_id,(CASE WHEN Date(ci_task.due_date) < CURDATE() AND ci_task.status <>'COMPLETE' THEN 'overdue' WHEN ci_task.assigner_id=ci_task.assignee_id THEN 'self' WHEN ci_task.assigner_id =$userID THEN 'assignee'  WHEN ci_task.assignee_id =$userID THEN 'assigner'  ELSE 'default'  END ) as type, ci_task.read")
    ->join('ci_customer','ci_customer.customer_id = ci_task.customer_id');

    $where = 'ci_task.assigner_id ='.$userID.' OR ci_task.assignee_id ='.$userID.'';
    $this->datatables->where($where);
    $this->datatables->edit_column('ci_task.task_id', btn_edit('admin/task/edit/' . '$1').' '.btn_sms('admin/task/sendSMS/' . '$1').' '.($this->session->userdata('role')?btn_delete('admin/task/delete/' .  '$1'):'')  ,'ci_task.task_id')
    ->from($this->_table_name);
    return $this->datatables->generate();
}

任何帮助都将不胜感激,谢谢。

如果您只是想知道如何显示复选框,那么jQuery数据表内置了此功能。您需要添加:
<input name="select_all" value="1" type="checkbox">

你可以在jsfiddle上查看这个例子http://jsfiddle.net/gyrocode/abhbs4x8/

在输入名称中使用方括号。

<input name="candidates[]" value="1" type="checkbox">
<input name="candidates[]" value="2" type="checkbox">
...