function.banner.php

<?php

function listBanner($sqladd=""){
global $cnf;
$sql = "SELECT * FROM banner ".$sqladd;
$dbc = dbQuery($sql);
if (mysql_num_rows($dbc) >= 1) {

while ($row = mysql_fetch_array($dbc)) {
//image
$row['filename'] = "<img width='260' height='103' src='media/banner_".$row['filename']."' border=0>";
if($row['status']==1)
$row['SELECTED']='checked';
$result[] = $row;

}
return $result;
} else {
return array();
}
}

function addBanner(){
global $cnf;
include_once(dirname(__FILE__).'/class.fval.php');
$check = new fval;
if (!isset($_GET['id'])){
if($_FILES['filename']['size']<=0)
$check->fval_customerror('Please Insert Your Image');
}
if ($check->fval_is_error()) {
$errorlist = $check->fval_get_errorlist();
foreach($errorlist as $key => $val) {
$errormsg .= '- '.$val.'<br>';
}
return $errormsg;
}else{
if($_POST['id']==""){
if (move_uploaded_file($_FILES['filename']['tmp_name'],$cnf['media']['dir'].'banner_'.$_FILES['filename']['name'])){
$sql="INSERT INTO banner(filename,product_id)
VALUES('".$_FILES['filename']['name']."',".$_POST['product_id'].")";
$dbc = dbQuery($sql);
}
}
return array();
}
}

function delBanner(){
global $cnf;
if(bannerIsExist($_GET["id"])){
deleteFile($_GET["id"]);
$sql = "DELETE FROM banner WHERE id=".$_GET["id"];
$dbc = dbQuery($sql);
return TRUE;
}else{
return false;
}
}

function listProductBanner(){
global $cnf;
$sql = "SELECT * FROM product";
$dbc = dbQuery($sql);
if (mysql_num_rows($dbc) >= 1) {
while ($row = mysql_fetch_array($dbc)) {
//image
$row['sname'] = $row['productcode']." - ". $row['name'];
$result[] = $row;

}
return $result;
} else {
return array();
}
}

function bannerIsExist($id)
{
global $cnf;
$sql = "SELECT COUNT(*) AS total FROM banner WHERE id=".(int)$id;
$dbc = dbQuery($sql);
if (mysql_result($dbc,0,'total') == 1) {
return TRUE;
} else {
return FALSE;
}
}

function showdetailBanner($id){
global $cnf;
$sql = "SELECT * FROM banner WHERE id=".(int)$id;
$dbc = dbQuery($sql);
if (mysql_num_rows($dbc) == 1) {
return mysql_fetch_array($dbc);
} else {
return array('asasd','asdas');
}
}

function deleteFile($id){
global $cnf;
$bannerdetail = showdetailBanner($id);
unlink($cnf['media']['dir'].'banner_'.$bannerdetail['filename']);
}

function bannerUpdate(){
$listStatus = $_POST['status'];
$sql = "UPDATE banner SET status=0";
$dbc = dbQuery($sql);
//print_r($listStatus);exit();
if(sizeof($listStatus)>0){
for($i=0;$i<count($listStatus);$i++){
$sql = "UPDATE banner SET status=1 WHERE id=".$listStatus[$i];
$dbc = dbQuery($sql);
}
}
}

?>