/** * Delete one */ public function deleteOne(manufacturer $m) { try { dibi::query('DELETE FROM [:prefix:manufacturers]', 'WHERE [id] = %i', $m->getId(), 'LIMIT 1'); dibi::query('DELETE FROM [:prefix:pages]', 'WHERE [nice_name] = %s', $m->getNiceName(), 'LIMIT 1'); return TRUE; } catch (Exception $e) { return FALSE; } }
if ($i % 2 == 0) { $style = "style='background-color:Khaki'"; } else { $style = ""; } echo "<tr {$style} >"; echo "<td><span class='clickspot' onclick='getDesc({$row['manufacturer_id']})'>{$row['manufacturer_name']}<span></td>"; echo "<td>{$row['manufacturer_id']}</td>"; echo "<td>{$row['address']}</td>"; echo "<td><a href='ed.php'>edit</a> -- <a href='searchManufacturer.php?manufacturer_name={$row['manufacturer_name']}'>delete</a></td>"; echo "</tr>"; $row = $obj->fetch(); $i++; } if (isset($_REQUEST['manufacturer_name'])) { echo $_REQUEST['manufacturer_name']; $obj = new manufacturer(); $manufacturer_name = $_REQUEST['manufacturer_name']; if (!$obj->delete_manufacturer($manufacturer_name)) { echo "Error deleting" . mysql_error(); } else { header("location:searchManufacturer.php"); } } ?> </div> </body> </html> }}}}
<td><input type ="text" name ="mn"></td></tr> <tr><td>Manufacturer ID</td> <td> <input type = "text" name = "mid"></td></tr> <tr><td>Address</td> <td><input type = "text" name ="aid"></td></tr> <tr><td colspan="2" align="center"><input type ="submit" value= "Save"></td></tr> </form> </table> </table> <?php if (isset($_REQUEST['mn'])) { include "manufacturersClass.php"; $obj = new manufacturer(); $manufacturer_name = $_REQUEST['mn']; $manufacturer_id = $_REQUEST['mid']; $address = $_REQUEST['aid']; if (!$obj->add_manufacturer($manufacturer_name, $manufacturer_id, $address)) { echo "Error adding" . mysql_error(); } else { echo " {$manufacturer_name} has successfully being added to the database"; } } ?> </div> </body>
/** * Count by manufacturer * @return int */ public function countByManufacturer(manufacturer $manufacturer, $letter = NULL) { try { $query = array('SELECT COUNT(*) FROM [:prefix:products] AS [products]'); if ($letter !== NULL) { $query[] = 'LEFT JOIN [:prefix:pages] AS [pages] ON [pages].[ref_id] = [products].[id] AND [pages].[ref_type] = %s'; $query[] = pages::PRODUCT; } $query[] = 'LEFT JOIN [:prefix:manufacturers] AS [manufacturers] ON [products].[manufacturer_id] = [manufacturers].[id]'; $query[] = 'WHERE [manufacturers].[id] = %i'; $query[] = $manufacturer->getId(); if ($letter !== NULL) { $query = array_merge($query, (array) 'AND', $this->whereLetter($letter)); } return dibi::query($query)->fetchSingle(); } catch (Exception $e) { return NULL; } }
/** * add/update manufacturer * * @return xml */ private function _setManufacturers() { global $db, $language; $manufacturers_id = (int) $_POST['mID']; $data = array(); $manufacturers_id = (int) $_POST['mID']; // default $data['manufacturers_id'] = $manufacturers_id; $data['manufacturers_name'] = $this->utf8helper($_POST['manufacturers_name']); $data['manufacturers_image'] = $_POST['manufacturers_image']; $data['manufacturers_status'] = '1'; $data['manufacturers_store_id'] = $this->store_id; // build lang vars foreach ($language->_getLanguageList() as $key => $val) { if ($val['code'] == 'de') { $val['languages_id'] = 2; } //$data['manufacturers_description_'.$val['code']] = $_POST['descr']; $data['manufacturers_url_' . $val['code']] = $_POST['manufacturers_url'][$val['languages_id']]; // $data['meta_description_'.$val['code']] = $_POST['categories_meta_description']; // $data['meta_keywords_'.$val['code']] = $_POST['categories_meta_keywords']; // $data['meta_title_'.$val['code']] = $_POST['categories_meta_title']; } $obj = new stdClass(); $manufacturer = new manufacturer(); $obj = $manufacturer->_set($data); if ($obj->success) { $status = array(); $status['code'] = '0'; $status['message'] = 'OK'; return $this->statusXMLTag($status); } else { $status = array(); $status['code'] = '99'; $status['message'] = 'PARAMETER ERROR'; return $this->statusXMLTag($status); } }
<?php echo $short_description; ?> <div class="cleaner"> </div> <?php echo $description; ?> <div class="cleaner"> </div> <?php if ($manufacturer) { ?> <p><?php echo Kohana::lang('eshop.manufacturer'); ?> : <?php echo manufacturer::get_name($manufacturer); ?> </p><?php } ?> <div class="cleaner"> </div> <?php if ($discount) { ?> <span class="discount"><?php echo Kohana::lang('eshop.discount'); ?> </span> <?php } ?> <?php