<?php
/*********************
 *********************
Template : "admin_lesson.php"
Controller : "Admin_Lesson.php"

 Creation 15/07/2019
 Aernout Guillaume
 https://codes.solutions
 *********************
 *********************/
 if (!defined('BASEPATH'))
   exit('No direct script access allowed');

class Admin_Shop extends NS_Controller {
    function __construct(){
       parent::__construct(array('no_cache'=>1));
       $this->load->helper('generator');
       $this->load->database();
       $this->load->model('shop_model');
    }
    function index(){
      $this->continueIfAllowed(array('allowed'=>array('admin')));

      $data['page_name'] = 'shop';
      $data['page_title'] = get_phrase('Shop');

      $this->load->view('backend/index',$data);
    }

    function submit(){
      $this->continueIfAllowed(array('allowed'=>array('admin')));
      $type = $this->input->post('type');

      //var_dump($_POST);
      if($type == "category"){
        $last_lvl =  $this->input->post('lvl');
        $last_id = $this->input->post('id');
        $title = $this->input->post('title');

        $query = $this->db->get_where('course_category',array('ID'=>$last_id));
        $last = $query->result_array();

        $parentId = $last[0]['Cat_Parent'];
        $sql = array(
          'Cat_Parent' => $parentId,
          'Cat_Level' => $last_lvl,
          'Cat_Title' => $title
        );

        //var_dump($sql);
        $this->db->insert('course_category',$this->crud_model->cleanArray($sql));
        $id = $this->db->insert_id();
        echo "$id";
      }else if($type == "subcategory"){
        $last_lvl =  $this->input->post('lvl');
        $last_id = $this->input->post('id');
        $title = $this->input->post('title');

        $sql = array(
          'Cat_Parent' => $last_id,
          'Cat_Level' => ($last_lvl+1),
          'Cat_Title' => $title
        );

        $this->db->insert('course_category',$this->crud_model->cleanArray($sql));
        $id = $this->db->insert_id();
        echo "$id";

      }else{
        $id = $this->input->post('id');
        $this->db->where('ID',$id);
        $this->db->delete('course_category');
      }
    }
    function edit(){
      $this->continueIfAllowed(array('allowed'=>array('admin')));
      $id = $this->input->post('id');
      $param = $this->input->post('param');

      $this->db->set(array('Cat_URL'=>$param));
      $this->db->where('ID',$id);
      $this->db->update('course_category');
    }
}