示例#1
0
 /**
  * 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>
示例#4
0
 /**
  * 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;
     }
 }
示例#5
0
 /**
  * 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);
     }
 }
示例#6
0
		<?php 
echo $short_description;
?>
		<div class="cleaner">&nbsp;</div>
		<?php 
echo $description;
?>
		<div class="cleaner">&nbsp;</div>
		<?php 
if ($manufacturer) {
    ?>
<p><?php 
    echo Kohana::lang('eshop.manufacturer');
    ?>
: <?php 
    echo manufacturer::get_name($manufacturer);
    ?>
</p><?php 
}
?>
		<div class="cleaner">&nbsp;</div>
		<?php 
if ($discount) {
    ?>
 <span class="discount"><?php 
    echo Kohana::lang('eshop.discount');
    ?>
</span> <?php 
}
?>
		<?php