Adding Opencart 2.x Admin Score And Expiration Date 2017

Adding Opencart 2.x Admin Score And Expiration Date 2017

• Article Images
• Article Video

---

---

• Description
• Reviews (1)

Hello friends today you are in versions available in OpenCart 2.x versions. We will share our article which includes 3 more data entries on Admin side and the related modifications on the database. In addition to the points and notes given to the product by admin in this article, if this product is a product with expiration date, it consists of the final date. This information entered from data entry in Admin section is structured to appear in product detail. Score notes and expiration dates entered from this section will be shown in the Product Manager.

Note: Friends have added +2 more fields in this modification, so this field allows entry of points for the related product. However, if I have not tested this modification for a while, first test it on localhost before using it and apply it to your own site. We do not accept liability for data loss.

Now let's set up.

Firstly. Creating the database from the model file by admin.

File Open : admin/catalog/model/catalog/

product.php

Find :

sku = '" . $this->db->escape($data['sku']) . "',

This code exists in two places. Replace it with the following code:

sku = '" . $this->db->escape($data['sku']) . "', entry_admin_notu = '" . $this->db->escape($data['entry_admin_notu']) . "', admin_notu = '" . $this->db->escape($data['admin_notu']) . "', entry_admin_puan = '" . $this->db->escape($data['entry_admin_puan']) . "', admin_puan = '" . $this->db->escape($data['admin_puan']) . "', entry_son_kullanma = '" . $this->db->escape($data['entry_son_kullanma']) . "', son_kullanma = '" . $this->db->escape($data['son_kullanma']) . "',entry_admini_puani_iki = '" . $this->db->escape($data['entry_admini_puani_iki']) . "', admini_notu_iki = '" . $this->db->escape($data['admini_notu_iki']) . "', entry_admini_puani_uc = '" . $this->db->escape($data['entry_admini_puani_uc']) . "', admini_puani_uc = '" . $this->db->escape($data['admini_puani_uc']) . "',

Find :

public function getProducts($data = array()) {

Add a substring under the code starting with $sql

$exist = $this->db->query("SHOW COLUMNS FROM `" . DB_PREFIX . "product` WHERE Field = 'entry_admin_notu'"); if (count($exist->row) == 0) { $this->db->query("ALTER TABLE `" . DB_PREFIX . "product` ADD COLUMN `entry_admin_notu` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `admin_notu` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `admini_notu_iki` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `admini_puani_uc` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `entry_admini_puani_iki` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `entry_admini_puani_uc` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `entry_admin_puan` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `admin_puan` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `entry_son_kullanma` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, ADD COLUMN `son_kullanma` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL "); }

File Open : admin/controller/catalog/

product.php

Find  :

$data['sku'] = '';

Add After Line :

if (isset($this->request->post['admin_notu'])) { $data['admin_notu'] = $this->request->post['admin_notu']; } elseif (!empty($product_info)) { $data['admin_notu'] = $product_info['admin_notu']; } else { $data['admin_notu'] = ''; } if (isset($this->request->post['admin_puan'])) { $data['admin_puan'] = $this->request->post['admin_puan']; } elseif (!empty($product_info)) { $data['admin_puan'] = $product_info['admin_puan']; } else { $data['admin_puan'] = ''; } if (isset($this->request->post['son_kullanma'])) { $data['son_kullanma'] = $this->request->post['son_kullanma']; } elseif (!empty($product_info)) { $data['son_kullanma'] = $product_info['son_kullanma']; } else { $data['son_kullanma'] = ''; } if (isset($this->request->post['admini_notu_iki'])) { $data['admini_notu_iki'] = $this->request->post['admini_notu_iki']; } elseif (!empty($product_info)) { $data['admini_notu_iki'] = $product_info['admini_notu_iki']; } else { $data['admini_notu_iki'] = ''; } if (isset($this->request->post['admini_puani_uc'])) { $data['admini_puani_uc'] = $this->request->post['admini_puani_uc']; } elseif (!empty($product_info)) { $data['admini_puani_uc'] = $product_info['admini_puani_uc']; } else { $data['admini_puani_uc'] = ''; }

Find :

$data['entry_download'] = $this->language->get('entry_download');

Add Before Line :

$data['entry_son_kullanma'] = $this->language->get('entry_son_kullanma'); $data['entry_admin_puan'] = $this->language->get('entry_admin_puan'); $data['entry_admin_notu'] = $this->language->get('entry_admin_notu'); $data['entry_admini_puani_iki'] = $this->language->get('entry_admini_puani_iki'); $data['entry_admini_puani_uc'] = $this->language->get('entry_admini_puani_uc');

Find  :

$data['help_ean'] = $this->language->get('help_ean');

Add After Lİne :

$data['help_admin_notu'] = $this->language->get('help_admin_notu'); $data['help_admin_puan'] = $this->language->get('help_admin_puan'); $data['help_admini_notu_iki'] = $this->language->get('help_admini_notu_iki'); $data['help_admini_puan_uc'] = $this->language->get('help_admini_puan_uc');

File OPen : admin/view/template/catalog/

product_form.tpl

Find :

<div class="form-group"> <label class="col-sm-2 control-label" for="input-sku"><span data-toggle="tooltip" title="<?php echo $help_sku; ?>"><?php echo $entry_sku; ?></span></label> <div class="col-sm-10"> <input type="text" name="sku" value="<?php echo $sku; ?>" placeholder="<?php echo $entry_sku; ?>" id="input-sku" class="form-control" /> </div> </div>

Add Before Line :

<!-- Eklemeler Buradn Başlar --> <div class="form-group"> <label class="col-sm-2 control-label" for="input-admin_notu"><span data-toggle="tooltip" title="<?php echo $help_admin_notu; ?>"><?php echo $entry_admin_notu; ?></span></label> <div class="col-sm-10"> <input type="text" name="admin_notu" value="<?php echo $admin_notu; ?>" placeholder="<?php echo $entry_admin_notu; ?>" id="input-admin_notu" class="form-control" /> </div> </div> <div class="form-group"> <label class="col-sm-2 control-label" for="input-admin_puan"><span data-toggle="tooltip" title="<?php echo $help_admin_puan; ?>"><?php echo $entry_admin_puan; ?></span></label> <div class="col-sm-10"> <input type="text" name="admin_puan" value="<?php echo $admin_puan; ?>" placeholder="<?php echo $entry_admin_puan; ?>" id="input-admin_puan" class="form-control" /> </div> </div> <div class="form-group"> <label class="col-sm-2 control-label" for="input-date-available"><?php echo $entry_son_kullanma; ?></label> <div class="col-sm-3"> <div class="input-group date"> <input type="text" name="son_kullanma" value="<?php echo $son_kullanma; ?>" placeholder="<?php echo $entry_son_kullanma; ?>" data-date-format="YYYY-MM-DD" id="input-date-available" class="form-control" /> <span class="input-group-btn"> <button class="btn btn-default" type="button"><i class="fa fa-calendar"></i></button> </span></div> </div> </div> <!-- Eklemeler Buradan Biter --> <!-- Eklemeler Buradn Başlar --> <div class="form-group"> <label class="col-sm-2 control-label" for="input-admini_notu_iki"><span data-toggle="tooltip" title="<?php echo $help_admini_notu_iki; ?>"><?php echo $entry_admini_notu_iki; ?></span></label> <div class="col-sm-10"> <input type="text" name="admini_notu_iki" value="<?php echo $admini_notu_iki; ?>" placeholder="<?php echo $entry_admini_puani_iki; ?>" id="input-admini_notu_iki" class="form-control" /> </div> </div> <div class="form-group"> <label class="col-sm-2 control-label" for="input-admini_puani_uc"><span data-toggle="tooltip" title="<?php echo $help_admini_puani_uc; ?>"><?php echo $entry_admini_puani_uc; ?></span></label> <div class="col-sm-10"> <input type="text" name="admini_puani_uc" value="<?php echo $admini_puani_uc; ?>" placeholder="<?php echo $entry_admini_puani_uc; ?>" id="input-admini_puani_uc" class="form-control" /> </div> </div> <!-- Eklemeler Buradan Biter -->

File Open  : admin/language/your-lang-file/catalog/

product.php

Find :

$_['help_ean']

Add After Line :

$_['help_admin_notu'] = 'Ürünlerde Yönetimden Girilen Notu'; $_['help_admin_puan'] = 'Ürünlerde Yönetimden Girilen Puanı'; $_['help_admini_notu_iki'] = 'Ürünlerde Yönetimden Girilen ikinci Puani'; $_['help_admini_puan_uc'] = 'Ürünlerde Yönetimden Girilen Üçüncü Puani';

Find :

$_['entry_name']

Add After Lİne :

$_['entry_admin_notu'] = 'Admin Notu'; $_['entry_admin_puan'] = 'Admin Puan'; $_['entry_son_kullanma'] = 'Son Kullanma'; $_['entry_admini_puani_uc'] = 'Admin Üçüncü Puani'; $_['entry_admini_puani_iki'] = 'Admin İkinci Puani';

Modification Process by Admin is Done. Imperial Rank came to visitor modifications

File OPen :  catalog/model/catalog/

product.php

Find :

viewed' => $query->row['viewed']

Add Before Lİne :

'admin_notu' => $query->row['admin_notu'], 'admin_puan' => $query->row['admin_puan'], 'son_kullanma' => $query->row['son_kullanma'], 'admini_notu_iki' => $query->row['admini_notu_iki'], 'admini_puani_uc' => $query->row['admini_puani_uc'],

File OPen : catalog/controller/product/

product.php

Find :

$data['reward'] = $product_info['reward'];

Add After Line :

$data['admin_notu'] = $product_info['admin_notu']; $data['admini_puani_uc'] = $product_info['admini_puani_uc']; $data['admini_notu_iki'] = $product_info['admini_notu_iki']; $data['admin_puan'] = $product_info['admin_puan']; $data['son_kullanma'] = $product_info['son_kullanma'];

Find :

$this->document->addStyle('catalog/view/javascript/jquery/magnific/magnific-popup.css');

Add After Line :

$this->document->addStyle('catalog/view/javascript/jquery/circle.css');

Find :

$data['entry_qty'] = $this->language->get('entry_qty');

Add After Line :

$data['entry_son_kullanma'] = $this->language->get('entry_son_kullanma'); $data['entry_admin_puan'] = $this->language->get('entry_admin_puan'); $data['entry_admin_notu'] = $this->language->get('entry_admin_notu'); $data['entry_admini_puani_iki'] = $this->language->get('entry_admini_puani_iki'); $data['entry_admini_puani_uc'] = $this->language->get('entry_admini_puani_uc');

File Open : catalog/language/senin-dil-klasörün/

product.php

Find :

$_['text_tags']

Add After Line :

$_['entry_son_kullanma'] = 'Kullanma Tarihi:'; $_['entry_admin_puan'] = 'Puanı:'; $_['entry_admin_notu'] = 'Notu:'; $_['entry_admini_puani_iki'] = 'İkinci Puani:'; $_['entry_admini_puani_uc'] = 'Üçüncü Puanı:';

File Open : catalog/view/theme/your-theme/template/product/

product.tpl

Find :

<?php if ($reward) { ?>

Add After Line :

<?php if ($admin_notu) { ?><span><?php echo $entry_admin_notu; ?>:</span> <?php echo $admin_notu; ?><br /><?php } ?> <?php if ($admin_puan) { ?><span><?php echo $entry_admin_puan; ?>:</span> <?php echo $admin_puan; ?><br /><?php } ?> <?php if ($son_kullanma) { ?><span><?php echo $entry_son_kullanma; ?>:</span> <?php echo $son_kullanma; ?><br /><?php } ?> <?php if ($admini_notu_iki) { ?><span><?php echo $entry_admini_puani_uc; ?>:</span> <?php echo $admini_notu_iki; ?><br /><?php } ?> <?php if ($admini_puani_uc) { ?><span><?php echo $entry_admini_puani_uc; ?>:</span> <?php echo $admini_puani_uc; ?><br /><?php } ?>

This is so if you want to make your score display a bit more lifelike. The sample code is as follows.

Find in the same tpl file:

<?php echo $header; ?>

Add After Line :

<link rel="stylesheet" href="css/circle.css">

You can add anywhere you want, you have

<?php if ($admin_puan) { ?> <div class="page"> <div class="c100 p<?php echo $admin_puan; ?> small"> <span><?php echo $admin_puan; ?>%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <?php } ?> <?php if ($admini_notu_iki) { ?> <div class="page"> <div class="c100 p<?php echo $admini_notu_iki; ?> small"> <span><?php echo $admini_notu_iki; ?>%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <?php } ?> <?php if ($admini_puani_uc) { ?> <div class="page"> <div class="c100 p<?php echo $admini_puani_uc; ?> small"> <span><?php echo $admini_puani_uc; ?>%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <?php } ?>

You can also add as many fields as you want by changing and duplicating the added tables and form elements. Css file is available.

Other different types of usage colors are as follows.

<div class="page"> <h1>Pure CSS Percentage Circle - circle100</h1> <!-- default --> <div class="clearfix"> <div class="c100 p50 big"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 small"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /default --> <!-- green --> <div class="clearfix"> <div class="c100 p50 big green"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25 green"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 small green"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /green --> <!-- orange --> <div class="clearfix"> <div class="c100 p50 big orange"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25 orange"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 small orange"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /orange --> <div class="dark-area clearfix"> <!-- default --> <div class="clearfix"> <div class="c100 p50 big dark"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25 dark"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 small dark"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /default --> <!-- green --> <div class="clearfix"> <div class="c100 p50 big dark green"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25 dark green"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 dark small green"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /green --> <!-- orange --> <div class="clearfix"> <div class="c100 p50 dark big orange"> <span>50%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p25 dark orange"> <span>25%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> <div class="c100 p12 dark small orange"> <span>12%</span> <div class="slice"> <div class="bar"></div> <div class="fill"></div> </div> </div> </div> <!-- /orange --> </div><!-- /.dark-area --> </div>

Write a review

Your Name

Your Review

Note: HTML is not translated!

Rating     Bad           Good

Continue