function get_product($id, $related = true)
{
$result = $this->db->get_where('products', array('id' => $id))->row();
$this->load->helper('string');
if (!$result) {
return false;
}
$related = json_decode($result->related_products);
if (!empty($related)) {
//build the where
$where = false;
foreach ($related as $r) {
if (!$where) {
$this->db->where('id', $r);
} else {
$this->db->or_where('id', $r);
}
$where = true;
}
$result->related_products = $this->db->get('products')->result();
} else {
$result->related_products = array();
}
$result->categories = $this->get_product_categories($result->id);
$result->description = correction($result->description);
// group discount?
if ($this->group_discount_formula) {
eval('$result->price=$result->price' . $this->group_discount_formula . ';');
}
return $result;
}
function form($id = false, $duplicate = false)
{
$this->product_id = $id;
$this->load->library('form_validation');
$this->load->model(array('Option_model', 'Category_model', 'Digital_Product_model'));
$this->lang->load('digital_product');
$this->form_validation->set_error_delimiters('<div class="error">', '</div>');
//$data['categories'] = $this->Category_model->get_categories_tierd();
//$data['product_list'] = $this->Product_model->get_products();
$data['file_list'] = $this->Digital_Product_model->get_list();
$data['page_title'] = lang('product_form');
//default values are empty if the product is new
$data['id'] = '';
$data['sku'] = '';
$data['name'] = '';
$data['slug'] = '';
$data['description'] = '';
$data['excerpt'] = '';
$data['price'] = '';
$data['saleprice'] = '';
$data['weight'] = '';
$data['track_stock'] = '';
$data['seo_title'] = '';
$data['meta'] = '';
$data['shippable'] = '';
$data['taxable'] = '';
$data['fixed_quantity'] = '';
$data['quantity'] = '';
$data['enabled'] = '';
$data['related_products'] = array();
$data['product_categories'] = array();
$data['images'] = array();
$data['product_files'] = array();
//create the photos array for later use
$data['photos'] = array();
if ($id) {
// get the existing file associations and create a format we can read from the form to set the checkboxes
$pr_files = $this->Digital_Product_model->get_associations_by_product($id);
$this->load->helper('string');
foreach ($pr_files as $f) {
$data['product_files'][] = $f->file_id;
}
// get product & options data
$data['product_options'] = $this->Option_model->get_product_options($id);
$product = $this->Product_model->get_product($id);
//if the product does not exist, redirect them to the product list with an error
if (!$product) {
$this->session->set_flashdata('error', lang('error_not_found'));
redirect($this->config->item('admin_folder') . '/products');
}
//helps us with the slug generation
$this->product_name = $this->input->post('slug', $product->slug);
//set values to db values
$data['id'] = $id;
$data['sku'] = $product->sku;
$data['name'] = $product->name;
$data['seo_title'] = $product->seo_title;
$data['meta'] = $product->meta;
$data['slug'] = $product->slug;
$data['description'] = correction($product->description);
$data['excerpt'] = $product->excerpt;
$data['price'] = $product->price;
$data['saleprice'] = $product->saleprice;
$data['weight'] = $product->weight;
$data['track_stock'] = $product->track_stock;
$data['shippable'] = $product->shippable;
$data['quantity'] = $product->quantity;
$data['taxable'] = $product->taxable;
$data['fixed_quantity'] = $product->fixed_quantity;
$data['enabled'] = $product->enabled;
//make sure we haven't submitted the form yet before we pull in the images/related products from the database
if (!$this->input->post('submit')) {
$data['product_categories'] = $product->categories;
$data['related_products'] = $product->related_products;
$data['images'] = (array) json_decode($product->images);
}
}
//if $data['related_products'] is not an array, make it one.
if (!is_array($data['related_products'])) {
$data['related_products'] = array();
}
if (!is_array($data['product_categories'])) {
$data['product_categories'] = array();
}
//no error checking on these
$this->form_validation->set_rules('caption', 'Caption');
$this->form_validation->set_rules('primary_photo', 'Primary');
$this->form_validation->set_rules('sku', 'lang:sku', 'trim');
$this->form_validation->set_rules('seo_title', 'lang:seo_title', 'trim');
$this->form_validation->set_rules('meta', 'lang:meta_data', 'trim');
$this->form_validation->set_rules('name', 'lang:name', 'trim|required|max_length[64]');
$this->form_validation->set_rules('slug', 'lang:slug', 'trim');
$this->form_validation->set_rules('description', 'lang:description', 'trim');
$this->form_validation->set_rules('excerpt', 'lang:excerpt', 'trim');
$this->form_validation->set_rules('price', 'lang:price', 'trim|numeric|floatval');
$this->form_validation->set_rules('saleprice', 'lang:saleprice', 'trim|numeric|floatval');
$this->form_validation->set_rules('weight', 'lang:weight', 'trim|numeric|floatval');
$this->form_validation->set_rules('track_stock', 'lang:track_stock', 'trim|numeric');
$this->form_validation->set_rules('quantity', 'lang:quantity', 'trim|numeric');
$this->form_validation->set_rules('shippable', 'lang:shippable', 'trim|numeric');
$this->form_validation->set_rules('taxable', 'lang:taxable', 'trim|numeric');
$this->form_validation->set_rules('fixed_quantity', 'lang:fixed_quantity', 'trim|numeric');
$this->form_validation->set_rules('enabled', 'lang:enabled', 'trim|numeric');
/*
if we've posted already, get the photo stuff and organize it
if validation comes back negative, we feed this info back into the system
if it comes back good, then we send it with the save item
submit button has a value, so we can see when it's posted
*/
if ($duplicate) {
$data['id'] = false;
}
if ($this->input->post('submit')) {
//reset the product options that were submitted in the post
$data['product_options'] = $this->input->post('option');
$data['related_products'] = $this->input->post('related_products');
$data['product_categories'] = $this->input->post('categories');
$data['images'] = $this->input->post('images');
$data['product_files'] = $this->input->post('downloads');
}
if ($this->form_validation->run() == FALSE) {
$this->load->view($this->config->item('admin_folder') . '/product_form', $data);
} else {
$this->load->helper('text');
//first check the slug field
$slug = $this->input->post('slug');
//if it's empty assign the name field
if (empty($slug) || $slug == '') {
$slug = $this->input->post('name');
}
$slug = url_title(convert_accented_characters($slug), 'dash', TRUE);
//validate the slug
$this->load->model('Routes_model');
if ($id) {
$slug = $this->Routes_model->validate_slug($slug, $product->route_id);
$route_id = $product->route_id;
} else {
$slug = $this->Routes_model->validate_slug($slug);
$route['slug'] = $slug;
$route_id = $this->Routes_model->save($route);
}
$save['id'] = $id;
$save['sku'] = $this->input->post('sku');
$save['name'] = $this->input->post('name');
$save['seo_title'] = $this->input->post('seo_title');
$save['meta'] = $this->input->post('meta');
$save['description'] = $this->input->post('description');
$save['excerpt'] = $this->input->post('excerpt');
$save['price'] = $this->input->post('price');
$save['saleprice'] = $this->input->post('saleprice');
$save['weight'] = $this->input->post('weight');
$save['track_stock'] = $this->input->post('track_stock');
$save['fixed_quantity'] = $this->input->post('fixed_quantity');
$save['quantity'] = $this->input->post('quantity');
$save['shippable'] = $this->input->post('shippable');
$save['taxable'] = $this->input->post('taxable');
$save['enabled'] = $this->input->post('enabled');
$post_images = $this->input->post('images');
$save['slug'] = $slug;
$save['route_id'] = $route_id;
if ($primary = $this->input->post('primary_image')) {
if ($post_images) {
foreach ($post_images as $key => &$pi) {
if ($primary == $key) {
$pi['primary'] = true;
continue;
}
}
}
}
$save['images'] = json_encode($post_images);
if ($this->input->post('related_products')) {
$save['related_products'] = json_encode($this->input->post('related_products'));
} else {
$save['related_products'] = '';
}
//save categories
$categories = $this->input->post('categories');
if (!$categories) {
$categories = array();
}
// format options
$options = array();
if ($this->input->post('option')) {
foreach ($this->input->post('option') as $option) {
$options[] = $option;
}
}
// save product
$product_id = $this->Product_model->save($save, $options, $categories);
// add file associations
// clear existsing
$this->Digital_Product_model->disassociate(false, $product_id);
// save new
$downloads = $this->input->post('downloads');
if (is_array($downloads)) {
foreach ($downloads as $d) {
$this->Digital_Product_model->associate($d, $product_id);
}
}
//save the route
$route['id'] = $route_id;
$route['slug'] = $slug;
$route['route'] = 'cart/product/' . $product_id;
$this->Routes_model->save($route);
$this->session->set_flashdata('message', lang('message_saved_product'));
//go back to the product list
redirect($this->config->item('admin_folder') . '/products');
}
}
