-
Notifications
You must be signed in to change notification settings - Fork 0
/
cls_stok.php
113 lines (103 loc) · 4.01 KB
/
cls_stok.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
<?php
class Stok{
var $tabloAd="stok";
public function StokSayiBul(){
$dba = new dbclass();
$dba->connect();
$sql=$dba->query("select count(id) sayi from ".$this->tabloAd);
$sonuc = $dba->fetch_object($sql);
return $sonuc;
}
public function StokGetir($urunid){
$dba = new dbClass();
$dba->connect();
//echo "select * from ".$this->tabloAd ." where id =$urunid";
$sql = $dba->query("select * from ".$this->tabloAd ."
where id =$urunid");
$sonuc = $dba->fetch_object($sql);
return $sonuc;
}
public function StoklariGetir($pagerWhere ="",$aramaString=""){
$dba = new dbClass();
$dba->connect();
//echo "select * from ".$this->tabloAd ." $aramaString order by id desc $pagerWhere";
$sql = $dba->query("select * from ".$this->tabloAd ." $aramaString order by id desc $pagerWhere");
while(@$sonuc =$dba->fetch_object($sql)){
$r[] =$sonuc;
}
return $r;
}
public function StoklariGetirGrubaGore($grupkod){
$dba = new dbClass();
$dba->connect();
//echo "select * from ".$this->tabloAd ." where anahtarlar like '%|$anahtarid|%'";
$sql = $dba->query("select * from ".$this->tabloAd ." where grupkod = '$grupkod' order by id");
while(@$sonuc =$dba->fetch_object($sql)){
$r[] =$sonuc;
}
return $r;
}
public function StoklariGetirEkGrubaGore($ekgrupkod){
$dba = new dbClass();
$dba->connect();
//echo "select * from ".$this->tabloAd ." where anahtarlar like '%|$anahtarid|%'";
$sql = $dba->query("select * from ".$this->tabloAd ." where ekgrupkod = '$grupkod' order by id");
while(@$sonuc =$dba->fetch_object($sql)){
$r[] =$sonuc;
}
return $r;
}
public function StokEkle($stokkod,$stokad,$grupkod,$ekgrupkod,$birim,$kdvoran,$aciklama,$alisfiyat,$satisfiyat){
$dba = new dbClass();
$dba->connect();
$cl = new Stok();
if($cl->StokVarmi($stokkod,0)==true){
$sonuc = "zatenvar";
}else{
//echo "insert into ".$this->tabloAd ." (stokad,anahtarlar) values('$stokad','$anahtarlar')";
$sql = $dba->query("insert into ".$this->tabloAd ." (stokkod,stokad,grupkod,ekgrupkod,birim,kdvoran,aciklama,alisfiyat,satisfiyat) values('$stokkod','$stokad','$grupkod','$ekgrupkod','$birim','$kdvoran','$aciklama','$alisfiyat','$satisfiyat')");
$sonuc = $dba->insert_id($sql);
}
return $sonuc;
}
public Function StokDuzenle($stokkod,$stokad,$grupkod,$ekgrupkod,$birim,$kdvoran,$aciklama,$alisfiyat,$satisfiyat,$stokid){
$dba = new dbClass();
$dba->connect();
$cl = new Stok();
if($cl->StokVarmi($stokad,$stokid)==true){
$sonuc="zatenvar";
}else{
$sql=$dba->query("update $this->tabloAd set stokkod='$stokkod', stokad ='$stokad', grupkod ='$grupkod', ekgrupkod='$ekgrupkod', birim ='$birim', kdvoran=$kdvoran, aciklama='$aciklama', alisfiyat=$alisfiyat, satisfiyat=$satisfiyat where id =$stokid");
$sonuc =$dba->affected_rows($sql);
}
return $sonuc;
}
public function StokVarmi($stokkod,$stokid)
{
$dba = new dbClass();
$dba->connect();
$sql = $dba->query("select count(id) sayi from ".$this->tabloAd ." where stokkod='$stokkod' and id <> $stokid");
$sonuc =$dba->fetch_object($sql);
if($sonuc->sayi>0){
return true;
}else{
return false;
}
}
public function StokSil($stokid){
$dba = new dbClass();
$dba->connect();
//$birimcls= new Birim();
$sql = $dba->query("delete from ".$this->tabloAd ." where id =$stokid");
$sql =$dba->query("select id from stok where stokid =$stokid");
/*while(@$sonuc =$dba->fetch_object($sql)){
$r[] =$sonuc;
}
foreach(@$r as $s){
$quizcls->BirimSil($s->id);
}*/
$sonuc=1;
return $sonuc;
}
}
?>