<?php if ( ! defined('BASEPATH')) exit('No direct script access allowed');


class Assignment_model extends CI_Model { 
	
	function __construct()
    {
        parent::__construct();
    }
	
   // The function below inserts into assignment table //
   function inserAssignment(){
    $page_data = array(
        'name'                      => html_escape($this->input->post('name')),
        'description'               => html_escape($this->input->post('description')),
        'class_id'                  => $this->input->post('class_id'),
        'subject_id'                => $this->input->post('subject_id'),
        'teacher_id'                => $this->input->post('teacher_id'),
        'timestamp'                 => $this->input->post('timestamp'),
        'file_type'                 => $this->input->post('file_type')
    );
    

//uploading file using codeigniter upload library
    $files = $_FILES['file_name'];
    $this->load->library('upload');
    $config['upload_path'] = 'uploads/assignment/';
    $config['allowed_types'] = '*';
    $_FILES['file_name']['name'] = $files['name'];
    $_FILES['file_name']['type'] = $files['type'];
    $_FILES['file_name']['tmp_name'] = $files['tmp_name'];
    $_FILES['file_name']['size'] = $files['size'];
    $this->upload->initialize($config);
    $this->upload->do_upload('file_name');

$page_data['file_name'] = $_FILES['file_name']['name'];
$this->db->insert('assignment', $page_data);
}

 // The function below updates assignment table //
 function updateAssignment($param2){
    $page_data = array(
        'name'                      => html_escape($this->input->post('name')),
        'description'               => html_escape($this->input->post('description')),
        'class_id'                  => $this->input->post('class_id'),
        'subject_id'                => $this->input->post('subject_id'),
        'teacher_id'                => $this->input->post('teacher_id'),
        'timestamp'                 => $this->input->post('timestamp'),
        'file_type'                 => $this->input->post('file_type')
    );

$this->db->where('assignment_id', $param2);
$this->db->update('assignment', $page_data);
}

// The function below delete from assignment table //
function deleteAssignment($param2){
    $this->db->where('assignment_id', $param2);
    $this->db->delete('assignment');
}


	
	
}

