【php开源代码栏目提醒】:网学会员--在 php开源代码编辑为广大网友搜集整理了:product.class.php绩等信息,祝愿广大网友取得需要的信息,参考学习。
<?php
class product extends comment {
var $fidlist,$layer;
var $up_img = 'upload/img/'; //图片上传地址
var $up_small_img = 'upload/smallimg/'; //缩略图地址
function product() {
parent::comment();
}
function add_sort($record) {
$sql = 'select count(id) as num from product_sort where name='.$record['name'].' and fid='.$record['fid'];
$rs = $this->DB->execute($sql);
$row = $rs->fields;
if($row['num']>0){
$this->msg("分类有重复!", "-1");
}
$this->_get_fid_info($record['fid']);
$sql = 'insert into product_sort(fid, name, fidlist, layer) values('.$record['fid'].',"'.$record['name'].'","'.$this->fidlist.'",'.$this->layer.')';
echo $sql;
$rs = $this->DB->execute($sql);
if($rs){
$this->msg("分类添加成功", 'product.php?act=sort_manage');
}else{
$this->msg("无法操作数据库,请稍后重试!", "-1");
}
}
function edit_sort($record) {
$sql = 'select count(id) as num from product_sort where name="'.$record['name'].'" and id<>'.$record['id'];
$rs = $this->DB->execute($sql);
$row = $rs->fields;
if($row['num'] > 0){
$this->msg("对不起,分类名重复!");
}
$this->_get_fid_info($record['fid']);
$sql = 'update product_sort set name="'.$record['name'].'" where id='.$record['id'];
if($this->DB->execute($sql)){
return true;
}else{
return false;
}
}
function del_sort($id) {
$sql = "DELETE FROM product_sort
WHERE id={$id}";
return $this->DB->Execute($sql);
}
function list_sort() {
$sql = 'select * from product_sort';
$rs = $this->DB->execute($sql);
$i=0;
while (!$rs->EOF()) {
$row = $rs->fields;
$arr[$i]['i'] = $i;
$arr[$i]['id'] = $row['id'];
$arr[$i]['fid'] = $row['fid'];
$arr[$i]['name'] = $row['name'];
$arr[$i]['fidlist'] = $row['fidlist'];
$arr[$i]['layer'] = $row['layer'];
$i++;
$rs->MoveNext();
}
return $arr;
}
function _get_fid_info ($fid) {
if($fid == 0) {
$this->fidlist = "0";
$this->layer = 0;
} else {
$sql = "select id,fidlist,layer from product_sort where id=$fid";
$rs= $this->DB->execute($sql);
$row = $rs->fields;
$this->fidlist = $row['id'].",".$row['fidlist'];
$this->layer = $row['layer']+1;
}
}
function get_count($sort_id = 0){
if($sort_id) {
$where = " and sort_id = {$sort_id}";
}else{
$where = "";
}
$sql = "SELECT COUNT(*) AS num FROM product_products
WHERE 1 = 1 {$where}";
$rs = $this->DB->Execute($sql);
$row = $rs->fields;
return $row['num'];
}
function list_product($st = 0, $sort_id = 0) {
$page_num = 30;
$pages = $this->build_pagelinks(array( 'TOTAL_POSS' => $this->get_count($sort_id),
'PER_PAGE' => $page_num,
'CUR_ST' => $st,
'BASE_URL' => "product.php?act=product_manage"
)
);
$this -> assign( "pages" , $pages);
$sql = 'select product_products.id,product_products.sort_id,product_products.name,product_products.puttime,product_products.size,product_sort.name as sort_name from product_products,product_sort where product_products.sort_id=product_sort.id order by product_products.orderby asc LIMIT '.$st*$page_num.','.$page_num;
$rs = $this->DB->execute($sql);
$i=0;
while(!$rs->EOF()){
$row = $rs->fields;
$arr[$i] = $row;
$i++;
$rs->MoveNext();
}
return $arr;
}
function add_product($record){
if($this->insert($record, 'product_products')) {
return $this->DB->Insert_ID();
} else {
return false;
}
}
function edit_product($record){
$condition = "id = '{$record['id']}'";
unset($record['id']);
if($this->update($record, 'product_products', $condition)) {
return true;
} else {
return false;
}
}
function del_product($id){
if(empty($id)){
$this->msg('对不起,产品ID不能为空!', -1);
}
$product_info = $this->get_product($id);
unlink($this->CONF['dir']['path'].$this->up_img.$product_info['img']);
unlink($this->CONF['dir']['path'].$this->up_small_img.$product_info['img']);
$sql = "DELETE FROM product_products WHERE id={$id}";
if($this->DB->execute($sql)){
return true;
}else{
return false;
}
}
function get_product($id){
if(empty($id)){
$this->msg('对不起,产品ID不能为空!', -1);
}
$
sql = "SELECT * FROM product_products
WHERE id = {$id}";
$rs = $this->DB->execute($sql);
$row = $rs->fields;
$row['content'] = $this->revert_value($row['content']);
return $row;
}
function get_so