function save($object = '', $related_field = '')
{
if (!$this->exists()) {
$o = new Productphoto();
$o->where('product_id', $this->product_id);
$o->select_max('position');
$o->get();
if (count($o->all) != 0) {
$max = $o->position + 1;
$this->position = $max;
} else {
$this->postion = 1;
}
}
return parent::save($object, $related_field);
}
function edit($id = 0, $productCatId = 0)
{
$product = new Product($id);
if (!$product->exists()) {
$product->isAutoGenerateUrl = 1;
$product->active = 1;
}
/**
* get list store
*/
$stores = new Store();
$stores->order_by('position', 'asc');
$stores->get_iterated();
$dis['stores'] = $stores;
if ($_SERVER['REQUEST_METHOD'] == "POST") {
$this->load->library('file_lib');
//save any param
$product->productCode = $this->input->post('productCode');
$product->name_vietnamese = $this->input->post('productName_vietnamese');
$product->name_english = $this->input->post('productName_english');
$product->name_japanese = $this->input->post('productName_japanese');
$product->des_vietnamese = $this->input->post('des_vietnamese');
$product->des_english = $this->input->post('des_english');
$product->des_japanese = $this->input->post('des_japanese');
$product->productstatu_id = $this->input->post('productstatu_id');
$product->productmanufacture_id = $this->input->post('productManufactureId');
$product->isSale = $this->input->post('isSale');
$product->saleOffPrice = $this->input->post('saleOffPrice');
$product->saleOffPriceText = $this->input->post('saleOffPriceText');
$product->price = $this->input->post('price');
$product->priceText = $this->input->post('priceText');
$product->isUsed = $this->input->post('isUsed');
$product->isGift = $this->input->post('isGift');
$product->isHot = $this->input->post('isHot');
$product->isNew = $this->input->post('isNew');
$product->seo_title = $this->input->post('seo_title');
$product->seo_description = $this->input->post('seo_description');
$product->seo_keyword = $this->input->post('seo_keyword');
$product->searchKey = $this->input->post('searchKey');
$product->txtDescription_vietnamese = $this->input->post('txtDescription_vietnamese');
$product->txtDescription_english = $this->input->post('txtDescription_english');
$product->txtGift = $this->input->post('txtGift');
$product->txtSumary = $this->input->post('txtSumary');
$product->txtVideo = $this->input->post('txtVideo');
$product->url_vietnamese = $this->input->post('url_vietnamese');
$product->url_english = $this->input->post('url_english');
$product->origin = $this->input->post('origin');
$product->warranty = $this->input->post('warranty');
$product->active = $this->input->post('isActive');
$product->promotion = $this->input->post('promotion');
$product->status = $this->input->post('productstatus');
$product->inBox = $this->input->post('inBox');
$product->isLinePrice = $this->input->post('isLinePrice');
$product->isLinePriceSaleOff = $this->input->post('isLinePriceSaleOff');
$product->isHighlightPriceSaleOff = $this->input->post('isHighlightPriceSaleOff');
$product->priceColor = $this->input->post('priceColor');
$product->saleOffPriceColor = $this->input->post('saleOffPriceColor');
$product->color = $this->input->post('color');
$product->weight = $this->input->post('weight');
$product->materials = $this->input->post('materials');
$product->size = $this->input->post('size');
$product->style = $this->input->post('style');
$product->productcat_id = $this->input->post('productcat_id');
if (trim($product->saleOffPrice) == "") {
$product->finalPrice = $product->price;
} else {
$product->finalPrice = $product->saleOffPrice;
}
if ($product->exists()) {
$product->updator = $this->logged_in_user->username;
} else {
$product->creator = $this->logged_in_user->username;
}
//check product representive image is available inside post request
if ($_FILES['logo']['name'] != "") {
$dataupload = $this->file_lib->upload('logo', 'img/products/');
if (is_array($dataupload)) {
$product->image = 'img/products/' . $dataupload['file_name'];
} else {
flash_message('error', $dataupload);
}
}
//first save
if ($product->save()) {
}
}
//create list product status
$productstatus = new Productstatu();
$productstatus->order_by('id', 'asc');
$productstatus->get()->all;
//create list productcomment.
/*$productcomments = new Productcomment();
$productcomments->order_by('id', 'desc');
$productcomments->where('product_id', $id);
$productcomments->get()->all;*/
//create list productphotos
$productphotos = new Productphoto();
$productphotos->where('product_id', $id);
$productphotos->order_by('position', 'asc');
$productphotos->order_by('id', 'desc');
$productphotos->get_iterated();
$accessories = $product->accessory;
$dis['accessories'] = $accessories;
$productSpec = new productspec();
$productSpec->where('product_id', $product->id);
$productSpec->order_by('position', 'asc');
$productSpec->get_iterated();
$productCat = $product->productcat;
$allSpec = new productspec();
if ($product->exists()) {
$allSpec->where('product_id', $product->id);
} else {
$allSpec->where('product_id', 0);
}
$allSpec->order_by('position', 'asc');
$allSpec->get_iterated();
//if create new product with productcat
if (!$product->exists()) {
if ($productCatId != 0) {
$productCat = new Productcat($productCatId);
$productSpec = $productCat->getSpec();
$allSpec = $productCat->getSpec();
}
}
$sitelanguage = new Sitelanguage();
$sitelanguage->order_by('position', 'asc');
$sitelanguage->get();
$dis['sitelanguage'] = $sitelanguage;
$productCat = new Productcat();
$productCat->order_by('position', 'asc');
$productCat->get_iterated();
$dis['productSpec'] = $productSpec;
$dis['productCat'] = $productCat;
$dis['allSpec'] = $allSpec;
//setPagination($this->admin.'productphoto/listAll/',$productphotos->paged->total_rows,$limit,4);
$dis['title_table'] = "Trang hiện tại:";
$dis['productphotos'] = $productphotos;
$dis['base_url'] = base_url();
$dis['object'] = $product;
$dis['productcomments'] = $productcomments;
$dis['productstatus'] = $productstatus;
$dis['title'] = "Thêm/ Sửa sản phẩm";
$dis['menu_active'] = "Sản phẩm";
$dis['view'] = "products/edit";
$dis['nav_menu'] = array(array("type" => "add", "text" => "Thêm sp khác", "link" => "{$this->admin_url}products/edit", "onclick" => ""));
if ($product->exists()) {
array_push($dis['nav_menu'], array("type" => "add", "text" => "Thêm hình ảnh", "link" => "{$this->admin_url}productphotos/edit/" . $product->id, "onclick" => ""));
} else {
$product->isAutoGenerateUrl = 1;
$product->isActive = 1;
}
$this->viewadmin($dis);
}
function setDefault($id)
{
$productphotos = new Productphoto($id);
$photo = new Productphoto();
$photo->where('product_id', $productphotos->product_id);
$photo->get_iterated();
foreach ($photo as $row) {
$row->isDefault = 0;
$row->save();
}
$product = new Product($productphotos->product_id);
$product->image = $productphotos->path;
$product->save();
$productphotos->isDefault = 1;
$productphotos->save();
//$this->resize_image($productphotos->path);
redirect($_SERVER['HTTP_REFERER']);
}
function detail()
{
$urlCat = $this->uri->segment(2);
if ($this->lang->lang() == 'vi') {
$productCat = new Productcat();
$productCat->where('url_vietnamese', $urlCat);
$productCat->get()->all;
if (!$productCat->exists()) {
redirect("");
}
} else {
$productCat = new Productcat();
$productCat->where('url_english', $urlCat);
$productCat->get()->all;
if (!$productCat->exists()) {
redirect("");
}
}
$dis['productCat'] = $productCat;
$url = $this->uri->segment(3);
$arrTitle = explode('.', $url);
if ($arrTitle[1] == '' || $arrTitle[1] != 'html') {
$this->cat();
}
$url = $arrTitle[0];
if ($this->lang->lang() == 'vi') {
$product = new Product();
$product->where('url_vietnamese', $url);
$product->where('productcat_id', $productCat->id);
$product->include_related('productphoto');
$product->get();
$product->view = $product->view + 1;
$product->save();
if (!$product->exists()) {
redirect("");
}
$this->page_title = $product->seo_title_vietnamese;
$this->page_description = $product->seo_description_vietnamese;
$this->page_keyword = $product->seo_keyword_vietnamese;
} else {
$product = new Product();
$product->where('url_english', $url);
$product->where('productcat_id', $productCat->id);
$product->include_related('productphoto');
$product->get();
if (!$product->exists()) {
redirect("");
}
$this->page_title = $product->seo_title_english;
$this->page_description = $product->seo_description_english;
$this->page_keyword = $product->seo_keyword_english;
}
$dis['product'] = $product;
// get all photo of product
$productphotos = new Productphoto();
$productphotos->where('product_id', $product->id);
$productphotos->order_by('position', 'asc');
$productphotos->order_by('id', 'desc');
$productphotos->get();
$dis['productPhotos'] = $productphotos;
$productPhotosActive = $productphotos->limit(1);
$dis['productPhotosActive'] = $productPhotosActive;
$productSame = new Product();
$productSame->order_by('id', 'desc');
$productSame->where('productcat_id', $productCat->id);
$productSame->where('id !=', $product->id);
$productSame->get_iterated();
$dis['productSame'] = $productSame;
$dis['base_url'] = base_url();
$dis['view'] = 'front/product/product_detail';
$this->viewfront($dis);
}
