C̆Bڅ.n pc򄏅1]x,w)I{ehtbS`=7cvGJE`{!mEp2;NA>So~!JOm"BW"űc-݄Q] R#05vMzrt&?? 6Hhw[` 6stq*B> tKAYxB[FjtBų-70hMxv=akiBw][1\SmCtK Nea /٤,Z H\sڻ@5F%⬆zGFb+0[[,}-w:H9+Q,uF`w׭TUUQMsJEΔBʣbc>biF6ՂsJa&w61тZ%z0X.9t C{5bޮ=delSރ@yo쥐FvW$BIyڈEl "&iI,+iĺJ99" nTHH?[֑G)`OjsmJ `)O&pS-pY!ϻmzى$E`[d0b';(Ʈ,8%glB@Bn&@VkʎV/9Hҿrxݨ"Ye)ЏcPXʡ~4!! @Ǧ04 HgeQC0wG0h4@X6N[f;m}BPy{!M_\ou9ϾF^og3 oF$6ɺBvrQR1+un#3%*-A@IHTRi #l4ɨ '˴~:WM47I]JW'9"4#E(^˸wԊ8e SYY(k4:]0~0*: ҕJ(Q\4Bs MLt43.j DYۚ/Y{ڽg͑+ϲwkrUX;F3HB³Da4\aZg\0R`c PE_o5~ 2Cl"׼9,,4q K0!ׁ-_ID$64.fâ`En6.g eX,*InD+A@Q(|I,/:&PfnkhT;y<_|J+aoBe+]X7rdK\%B7aH&~Cgi7ZۅxVgavW g=&W=W5zx4m`[h0@{QCC!(uLV#q""b(V*;r"ZSBۧwg_akWcז5XW=bz|ߠhhYuwxA!.֡k֚8e`[l1ZT -BC:<**6J~F{ 4 j'o{}cCYX-HZ9 ݌svlG0]$>!9JrpMN[*I=%O$ZњҼMS4TwX'ӹ2o6P .d5ޘ%4/G7+4Tv0f<>%zM%8S)bV9Ho9b>O ڍ7e7$%u n~7GOӞf3zW$=Q- lEą@ߚmU^h”SuQ^|gK߮ʱ>TUV<#la8ׂQZ#~!i)3x f%ψv K ٨يfx4AmN3J>lO&%~B Lwܡi J,7}~Κ=Z%$$Py=#Bl{Xb% c7?Eof--|BlT#Pu=o?uyekI*#J;](E܁L 1͑%,ũ87نF.7$R@$2S=#}Q(~kHSug#jQEx}i\THW#ޘ;vW 6қjQ?+h6KrSuVf؜X'Ӊ醊VfkޚiyoB(hN,l-k{R(6"aӾ`bP@P.3xɈJE_5Ͳ}V@C>(l.,hZ 6`IL &xA)nslM{5 6+ʘA5z# p2h\e FTd[t[baK4{*@vؾ! {zMbߩ620:!X, @xN[u2Aۇ'끴%[~Q;0J(}a/atb{;xRW1!(CAS^CQ 3ƱDm!\(*w%y ӠlMzY2&sUDTз{۴ғDt7 ׮ "s?l? ju+v_㲿pCIx.nhgl7vbc*˲beQuĬ{a;|侼 vQoq I\X%d )ya$cؘ3M^UUls+0bi:S+eפֿØ$)ZT"1<K^J]nP˓ʛ6MEc-H`r&;e+4n} ͢-+#%ۮI2/VI"k3|JɟKm`Lcɵ0οdUP\kYՏ}cR\ǤY콍,  X)O, F k[`!T6=oSqҷ%掭87u i9pL"r*݆ȡGgm-S!=LŌ?L z#z t4ӴnFJUˉakk6‰d}j$cڐ2󁅺jOhPILCC<!i]* P7ż[#1IǓ&+&mvh:% ijWZ[jJ J|@ざMaʢr13b}yQˊH$g) GDr#Ћu:ʌMr-%j%/=k6' 5eG6>5HJP-7΍}hBJܼ=F$ N@WqM"^ӈXBm.uם30 wuFtD<+V//.BBsEhmV6zQF / ڧֶ#K:ܝ(QPʶ;,dutӫ!Rre]\=Μ`9Jx'uqXvm,Fp)-&7RN;ހeyO=wjئRbкL,[G{"ka+6b%(%S'ELcmɩ*:g^yQJ13'3(FzֶѣI%Fq6J@PGV5\-iCd&)b(pbbq>x] `-&oh)_VO!t2S&PHF{k$˟P`%fp(N$h;ia( p^dK68N`ћ[4US;x:zQ!WT[Ѳg'; @")` z|(%WF$+O[8uQqKG9F9{juv°ƪB( Egh՛$$Fά,L~̏=;qZuN-ɝrWEQpt eK.7n4od;= ~O }rr-tY|VI(XJzfU{8Ɖb/DZ,%nfEDIFyE>/YVO/C(L1Ogpo-Z6,n"F&|m,X`;zFI 3GaOٚXeAwz*y4,|uFLwn M*4;Ќҷ}6W= A`? +r4 skpБx7f{ l]sϧl{@o&m\d$\VYEU }`I8S>j727r$w o6 wѺޥy&XN @roTE)+q-,#8LY_@,TXoN 6Khc.rosӶ|o{ =Xjxяȵ!ݺY'}9AGePhKmЩm89Il >3NLGGJRWg$`L*h8sԻ#^Q4i6T~O,~}=&xoIFu?nd,K4nrYwƻwYc١.0d,&,c*aRMb=4'9xq𒔩f Y5d=Cj=?.jpgxWyY7\cγ7g8 1/#Zuco&]=0+T.m ϳ)ȳKWy@h|n&k#δax?$՞Hp˒:u-?5`|ȔD_{([s >r,qXA_{TP=RFf41qГh5d4eIВ\l4iLGV\N˶FCi2;Ǖ~C sa :͐K$|\zJk),:IJ@ (int) date("s", $diff) ); } // ---------------------------------------------------- // Log File function log_ls_file($log_inhalt) { global $ordner; $tmp_log_file = date("Y_m")."_ls_log.txt"; $log_file = fopen ($ordner."log_files/ls_laden_retour/$tmp_log_file", "a+"); chmod ($ordner."log_files/ls_laden_retour/$tmp_log_file", 0777); $datum_text = "---------- ".date("Y.m.d.")." ----------\r\n"; $datum_input = true; while (!feof($log_file)) { $zeile = fgets($log_file, 4096); if (preg_match("/".date("Y.m.d.")."/",$zeile)) $datum_input = false; } if ($datum_input) fwrite($log_file,"$datum_text"); // Log Inhalt schreiben if ($log_inhalt) fwrite($log_file,date("H:i:s - ")."$log_inhalt\r\n"); fclose($log_file); } // ------------------ // Log File function log_kv_file($log_inhalt) { global $ordner; $tmp_log_file = date("Y_m")."_kv_log.txt"; $log_file = fopen ($ordner."log_files/kv_log/$tmp_log_file", "a+"); chmod ($ordner."log_files/kv_log/$tmp_log_file", 0777); $datum_text = "---------- ".date("Y.m.d.")." ----------\r\n"; $datum_input = true; while (!feof($log_file)) { $zeile = fgets($log_file, 4096); if (preg_match("/".date("Y.m.d.")."/",$zeile)) $datum_input = false; } if ($datum_input) fwrite($log_file,"$datum_text"); // Log Inhalt schreiben if ($log_inhalt) fwrite($log_file,date("H:i:s - ")."$log_inhalt\r\n"); fclose($log_file); } // ------------------ // Bildbearbeitung -------- function bild_bearbeiten($bilddir,$bild,$h_max,$b_max) { chmod($bilddir, 0777); // Bilddaten feststellen // Breite: 0, Höhe: 1, Typ: 2 $image_type = getimagesize($bilddir.$bild); // image_type[2] = (1 = gif, 2 = jpeg, 3 = png) if ($image_type[2] == 1 || $image_type[2] == 2 || $image_type[2] == 3) { $breite = $image_type[0]; $hoehe = $image_type[1]; // Checken ob Hochformat oder Querformat // Hochformat if ($hoehe > $breite && $hoehe > $h_max) { $neueHoehe = $h_max; $neueBreite = intval($breite*$neueHoehe/$hoehe); } // Querformat elseif ($hoehe < $breite && $breite > $b_max) { $neueBreite = $b_max; $neueHoehe = intval($hoehe*$neueBreite/$breite); } // hoehe & breite < max else { $neueHoehe = $hoehe; $neueBreite = $breite; } $neuesBild = ImageCreateTrueColor($neueBreite,$neueHoehe); $black = imagecolorallocate($neuesBild, 0, 0, 0); if($image_type[2]==1) { // GIF $altesBild = ImageCreateFromGIF($bilddir.$bild); ImageCopyResampled($neuesBild,$altesBild,0,0,0,0,$neueBreite,$neueHoehe,$breite,$hoehe); ImageGIF($neuesBild,$bilddir."tmp_".$bild,90); } if($image_type[2]==2) { // JPG $altesBild=ImageCreateFromJPEG($bilddir.$bild); ImageCopyResampled($neuesBild,$altesBild,0,0,0,0,$neueBreite,$neueHoehe,$breite,$hoehe); ImageJPEG($neuesBild,$bilddir."tmp_".$bild,90); } if($image_type[2]==3) { // PNG imagecolortransparent($neuesBild, $black); $altesBild=ImageCreateFromPNG($bilddir.$bild); ImageCopyResampled($neuesBild,$altesBild,0,0,0,0,$neueBreite,$neueHoehe,$breite,$hoehe); ImagePNG($neuesBild,$bilddir."tmp_".$bild,90); } unlink($bilddir.$bild); rename($bilddir."tmp_".$bild,$bilddir.$bild); /* // dpi anpassen // muss vor der bearbeitung stehen // Read the file $size = filesize($bilddir.$bild); $image = file_get_contents($bilddir.$bild); // Update DPI information in the JPG header $image[13] = chr(1); $image[14] = chr(floor(150/255)); // 150 dpi $image[15] = chr(150 % 255); // 150 dpi $image[16] = chr(floor(150/255)); // 150 dpi $image[17] = chr(150 % 255); // 150 dpi // Write the new JPG $f = fopen($bilddir.$bild, 'w'); fwrite($f, $image, $size); fclose($f); // ---------- */ chmod($bilddir.$bild, 0777); ImageDestroy($neuesBild); } // if images_type = 1,2,3 } // function bild_anpassen // +++++++++++++++++++ FARBPALETTE ++++++++++++++++++++++ function farb_decode($z1,$z2,$wert) { $decode = array('0'=>'0','1'=>'1','2'=>'2','3'=>'3','4'=>'4','5'=>'5','6'=>'6','7'=>'7','8'=>'8','9'=>'9','a'=>'10','A'=>'10','b'=>'11','B'=>'11','c'=>'12','C'=>'12','d'=>'13','D'=>'13','e'=>'14','E'=>'14','f'=>'15','F'=>'15'); $farbe = 16 * $decode[$z1] + $decode[$z2] + $wert; if ($farbe > 255) $farbe = 255; return $farbe; } // function decode function farb_encode($z) { $encode = array('0'=>'0','1'=>'1','2'=>'2','3'=>'3','4'=>'4','5'=>'5','6'=>'6','7'=>'7','8'=>'8','9'=>'9','10'=>'A','11'=>'B','12'=>'C','13'=>'D','14'=>'E','15'=>'F'); if ($z < 16) $farbe = "0".$encode[$z]; else { $r1 = $z / 16; $r2 = $z - (floor($r1) * 16); $farbe = $encode[$r1].$encode[$r2]; } return $farbe; } // function encode function colorchange($farbe,$wert) { for ($i=1;$i<=6;$i++) { $f[$i] = substr($farbe,$i-1,1); $f[$i+1] = substr($farbe,$i,1); $i++; } // split $farbe_n[1] = farb_decode($f[1],$f[2],$wert); $farbe_n[2] = farb_decode($f[3],$f[4],$wert); $farbe_n[3] = farb_decode($f[5],$f[6],$wert); $farbe_neu = ""; for ($i=1;$i<=3;$i++) $farbe_neu .= farb_encode($farbe_n[$i]); return $farbe_neu; } // function colorchange // +++++++++++++++++++++++++ FARBPALETTE ENDE ++++++++++++++++++++++ // Von, bis = Abholung, Retour // int = + oder - Stk // Typ: fix oder res (String) function ArtsProTag($von,$bis,$int,$typ) { global $array_res_fix,$array_res_res; $von = strtotime($von); $bis = strtotime($bis); $i = $von; while ($i <= $bis) { if ($typ == "fix") $array_res_fix[$i] += $int; else $array_res_res[$i] += $int; $i += 86400; } } // function function ArtsProStunde($von,$bis,$int,$typ) { global $array_res_fix,$array_res_res; $von = strtotime($von); $bis = strtotime($bis); $i = $von; while ($i <= $bis) { if ($typ == "fix") $array_res_fix[$i] += $int; else $array_res_res[$i] += $int; $i += 3600; } } // function function ArtsProHalbTags($von,$bis,$int,$typ) { global $array_res_fix,$array_res_res; $von = strtotime($von); $bis = strtotime($bis); $i = $von; while ($i <= $bis) { if ($typ == "fix") $array_res_fix[$i] += $int; else $array_res_res[$i] += $int; $i += 43200; } } // function // Artikel Lagerbestand auslesen + ist Artikel in einem Rack? function art_lagerbestand($art_id) { global $dbConnection_shop,$table_shop_artikel; $query_art = mysqli_query($dbConnection_shop,"select anzahl,is_rack from $table_shop_artikel where id = $art_id limit 1"); if ($query_art && mysqli_num_rows($query_art)) { $array[0] = mysqli_result($query_art,0,"anzahl"); $array[1] = mysqli_result($query_art,0,"is_rack"); return $array; } } // function // Artikel CHECK function artikel_check($art_id,$von,$bis,$master_id) { global $dbConnection_shop,$table_veranstaltungsartikel,$table_veranstaltung_main; $query = mysqli_query($dbConnection_shop,"select MAX(a.artikel_anz) max_anz from $table_veranstaltungsartikel a LEFT JOIN $table_veranstaltung_main b ON a.v_main_id = b.id where ( ($von <= a.von and $bis >= a.von and a.artikel_id = $art_id and a.is_set = 0) or (a.von <= $von and $bis <= a.bis and a.artikel_id = $art_id and a.is_set = 0) or ($von <= a.bis and a.bis <= $bis and a.artikel_id = $art_id and a.is_set = 0) ) and ( (b.kv_fix <> 0 and b.completed <> 3) or (b.kv_ansicht <> 0 and b.master_id = '$master_id' and b.completed <> 3) or (b.kv_ansicht <> 0 and b.master = 1 and b.completed <> 3) )"); if ($query && mysqli_num_rows($@ Q.ڨJh'$-|{̮ hQb!ʥ &zHztqtͤvT-Bü*%hLaH'`0G"!5)Q;F7tb0GzKD8o]uJH/~/d)Qq"P֮5T0h?RquMUR6BCyv_7ݡ/^ 'ܵi,a#mi4HEqzsdKoπ7]'_>6w=K}lvk^@ܜ㫏6,)0!1h=A܍׾7&9]8;l0b3qT:pcVg@5)Cd'Dw%=W9tvjk}lA U >E~U?Z6;VgvqfQƛ4!z/xaƏJr|ļT|EHh~B!꧆8rR}u7֡0\Km)E(SsU (󥎳18NjN#?~ /%Ө>ebaĤ>~F3C~"%,*!(oE #{*;x=C0!PoN$)MʩV.i4ͦYgR猑KD:2B6EؐwŤ`k9wỈgW!q#\ Wyl&Rw76LQlLd>SGN%Ac w n8\@r2R.-n;WpwS_Rn&&IP -,=yxR˻^;kX _`Vۈö,KK-ݿnRrQܒ8N)RKz Uk;]']6t)8z3=\ J1VnDQ>C4wu}ci8IuDFUXd]BAу,>}8xZ"$G c ?ى5pr{bڦ=^U3# A捞d|*8:F]0}\qE5 E4U.OWQ80FMQӔj;d1P7V(k6sPΠ1Sw7 cN*;( _O-^M۟+H ra6}$m,xs'B>Լf`MQ. iK잍PK NCx}>w;G$qGbHtT\İQ*}OmQGxPgޅH{6F;W_@ |9Q6* zxIծlDkpE@eFrp(_ _:[Mo?&dV@1*[zsZ/Gc Ѡ7/3TH =.iX뛷hUU[&`ǥF>_4韚Kݮ|{7K յW4&DНq)}~"UތC<2&NX%n#(c ? z' h;f_OPPci%/h׎qiwiOh m⼻xh M\.bK*ŚZ6Dv|ZSwPipkcP߃7m6@  Y^>0Y]fʋAJAa=J|p)^NS'|` qSYlJP'‘BG QTLnHm4V|y ԇ+о \CS}ؓs6}]p O}9$fMֽ\Yd ej6-@NsaZ₇*~Ķcu,X| B km;@ģ?"V GO^5 W2>=M8jV<o+j(9vI'HV[:&C^Ȳ(> q%T4ʦ\+;Nz1]QH ޙkE%Թ?ܠHF]W\$-'rV} JvW v A_r`5 }M-h'=8&"Z.PF}nBn 4l%)K%M;W8׾nzRk*a\JF8be,q[I'[ /""ti]Boe耾FP2ؤ\&aE Cb\FsO `PPpw0ivF 洠H!wh?竷QbKmMbR1V~GI56tтNO@} ZA.ZoʩS<$Ⱥ[9|\>Z8#}jHͭdGK+`1׹NhC K]=Jt"! ԁOHʼnm'҆~h1$v":8[׃9u8)ՋXY!:+[4j;q~}㛲"._Ex 'I̻lhnF̰H@0i~"b.P\DDV@[y{.V=Ayqxv$jx$Y$KwKQu4zS|O~q0axHkS[clzMY=lҏJ+dN@>WˠXwpUMMqcÆ16X'} ѥKR] ݻ FdÒ瀱YS?Ceb^wZ/+Az HQuꐊ'OVwUBbR3%ߗ" ,Fmil뙫} ۢP2?vè:OV A#mW]J-.:ߖfǾݢN.f)e=kHceYy`AhFQq3^:_GRfcis::FN,U4BA*y[GʠXSě:eX=<^Fcނ{{44W"CђLȠOaME' ~퟇{ϒFØy OJv7 $fRfc^' :߈_m>s%:!(3" s"(8k;7u1 mvw_2W~m7\TP HdDqTLnyq5T5j TM׷``wf#rpn(+|m[PV{^ao§90 wTmJ%"L"!7kggEH6yӥLeyW;aYd2dN7>ik/jPsoeykrmun͚&nN/lz*X>DX/!AUy_4ؽTsug$ caDK;(3*=WR}̠%p+ZZi(O2+}U `0g{Mut)xʏlD#*~5"./x,#!srvZ(-"t wnԚc/'FDs^xI` (ʩPA6N"~}Bּ bP[u@E4EGinN3wrB\pڍϱ<1na۴:6,8~kX Rˀ~ LFyE$Ξ:U3 Swsaquq1-ݴK/8ՌbpIƑ?+"D~z-z;O/[+>X9DE@p g,޸=);cvQbGfOʸW0@u62gk4?ecl^kd^33E-Fq`4 f0&V%#۱y= Gϡ%FsN|w`P{(4L.rV{xg50"S{1&?:JrQ)~7+5LY` ގVXovW\3{u !íuS.(sUh9;LyӁ?pFMPV0l8C)#/ѽڿMj9Qwa3@9:xeߏ8 zx}y/Ae9pՅH7`QǾIIZ("W((au9k ]=qg0=fUOW3\n&"]X gʟe0`icXCjIlDյ9B_򞒌['_!(,' cSObvtaDAC<](M@s+[` hL2vTw͗5‚Nk_yI![ V]J]P.95ϹW8bJ;s Gkqmk6aXpg}~CMS'aN)<7Htvh T4: _? =V;X"4 fdxۣ꠮3L;+' WIfC/aompl&BP.bƶΉ2Lx"j>4-W. _hz籧DeyE*C]Q[䣓*]cξmo 7f  P%}t1'bR-6/];z,"]m['m̒*{澸~5 w_[ax-T%ΆT.ba%!jƁj(/6S9[L˅u]YXַP3xgk9H;++ܿ XAa {0c_v󪓲6[B3 y[J^9\x' c3BՠԆ1_[Y_\+O*r8b[>|e| "]BЇ+7 M, cBeFϹG/9z 77N#$Bu 7ZTᙦQC|?vpa[ [ݶeQelse return "User unbekannt"; } function function_print() { // NEU /* echo " "; */ // ALT: echo ""; // Noch älter: /* echo ""; */ } function function_print2() { echo ""; } function function_quick_print() { echo " \n"; } function function_quick_print2() { echo " \n"; } function back($align) { if ($align) echo "
"; echo "  « zurück  "; if ($align) echo "
"; } function backlink($align,$link) { if ($align) echo "
"; echo "  « zurück  "; if ($align) echo "
"; } function close($align) { if ($align) echo "
"; echo "  » Fenster schließen «  "; if ($align) echo "
"; } function window_close() { echo ""; } /* VA_STATUS bearbeiten ------- ----------------- ------------- va_status (varchar 100) - (KV, LSL, LSF, LSR) KV: Artikel im KV LSL: geladene Artikel LSF: fixierte Artikel LSR: retournierte Artikel */ function func_va_status($v_id,$typ,$wert) { global $dbConnection_shop,$table_veranstaltung_main,$table_lieferschein_artikel; $query = mysqli_query($dbConnection_shop,"select master_id,va_status from $table_veranstaltung_main where id = '$v_id' limit 1"); if ($query && mysqli_num_rows($query)) { $master_id = mysqli_result($query,0,"master_id"); $va_status = mysqli_result($query,0,"va_status"); # H-VA if ($master_id) { $query_h = mysqli_query($dbConnection_shop,"select va_status from $table_veranstaltung_main where id = '$master_id' limit 1"); if ($query_h && mysqli_num_rows($query_h)) $va_status_h = mysqli_result($query_h,0,"va_status"); } $split = $split_h = array(); $split = explode(",",$va_status); if ($master_id) $split_h = explode(",",$va_status_h); if ($typ == "KV") { $split[0] += $wert; $split_h[0] += $wert; } elseif ($typ == "LSL") { $split[1] += $wert; $split_h[1] += $wert; } elseif ($typ == "LSR") { $split[3] += $wert; $split_h[3] += $wert; } elseif ($typ == "LSF") { $query2 = mysqli_query($dbConnection_shop,"select sum(art_anz) sum from $table_lieferschein_artikel where v_main_id = '$v_id' and date_fix > 0"); if ($query2 && mysqli_num_rows($query2)) $split[2] = mysqli_result($query2,0,"sum"); # Für H-VA gibt es kein FIX-Check # split_h[2] = split_h[2] } // Rundung wegen Float Summen, sonst 10 stellig $split[0] = round($split[0],2); $split[1] = round($split[1],2); $split[2] = round($split[2],2); $split[3] = round($split[3],2); $input = $split[0].",".$split[1].",".$split[2].",".$split[3]; # alert($input); if ($split[0]) mysqli_query($dbConnection_shop,"update $table_veranstaltung_main set va_status = '$input' where id = '$v_id'"); # H-VA if ($master_id) { $input = $split_h[0].",".$split_h[1].",".$split_h[2].",".$split_h[3]; mysqli_query($dbConnection_shop,"update $table_veranstaltung_main set va_status = '$input' where id = '$master_id'"); } } // if query } // function /* in: -) va_unten -) ls_ansichten/ls_artikel_status */ function func_va_status_reset_calc($v_id) { global $dbConnection_shop,$table_veranstaltung_main,$table_veranstaltungsartikel,$table_lieferschein_artikel; $query = mysqli_query($dbConnection_shop,"select kv_fix from $table_veranstaltung_main where id = '$v_id' limit 1"); if (mysqli_num_rows($query)) { $kv_fix = mysqli_result($query,0,"kv_fix"); if ($kv_fix > 0) { // KV $query = mysqli_query($dbConnection_shop,"select sum(artikel_anz) sum from $table_veranstaltungsartikel where v_main_id = '$v_id' and kv = '$kv_fix' and is_set <> 1"); if ($query && mysqli_num_rows($query)) $kv = mysqli_result($query,0,"sum"); if (!$kv) $kv = 0; // LSL $query = mysqli_query($dbConnection_shop,"select sum(art_anz) sum from $table_lieferschein_artikel where v_main_id = '$v_id'"); if ($query && mysqli_num_rows($query)) $lsl = mysqli_result($query,0,"sum"); if (!$lsl) $lsl = 0; // LSF $query = mysqli_query($dbConnection_shop,"select sum(art_anz) sum from $table_lieferschein_artikel where v_main_id = '$v_id' and date_fix > 0"); if ($query && mysqli_num_rows($query)) $lsf = mysqli_result($query,0,"sum"); if (!$lsf) $lsf = 0; // LSR $query = mysqli_query($dbConnection_shop,"select sum(art_anz) sum from $table_lieferschein_artikel where v_main_id = '$v_id' and date_retour > 0"); if ($query && mysqli_num_rows($query)) $lsr = mysqli_result($query,0,"sum"); if (!$lsr) $lsr = 0; // Rundung wegen Float Summen, sonst 10 stellig $kv = round($kv,2); $lsl = round($lsl,2); $lsf = round($lsf,2); $lsr = round($lsr,2); mysqli_query($dbConnection_shop,"update $table_veranstaltung_main set va_status = '$kv,$lsl,$lsf,$lsr' where id = '$v_id'"); // Artikel_anz_ls darf nicht größer sein als Artikel_anz $query = mysqli_query($dbConnection_shop,"select id from $table_veranstaltungsartikel where v_main_id = '$v_id' and kv = '$kv_fix' and is_set <> 1 and artikel_anz < artikel_anz_ls"); if ($query && mysqli_num_rows($query)) { while ($sql = mysqli_fetch_assoc($query)) { mysqli_query($dbConnection_shop,"update $table_veranstaltungsartikel set artikel_anz_ls = artikel_anz where id = '".$sql["id"]."'"); } } // ----- return array($kv,$lsl,$lsf,$lsr); } // if kv_fix else return array(); } // if num_rows (kv_fix) else return array(); } // function function func_va_status_reset($v_id) { global $dbConnection_shop,$table_veranstaltung_main; $array_status = array(); $query = mysqli_query($dbConnection_shop,"select master from $table_veranstaltung_main where id = '$v_id' limit 1"); if ($query && mysqli_num_rows($query)) { $master = mysqli_result($query,0,"master"); if ($master) $array_status = func_va_status_reset_HS($v_id); else $array_status = func_va_status_reset_calc($v_id); } // if num_rows (kv_fix) return $array_status; } // function // Status einer Hauptveranstaltung erstellen function func_va_status_reset_HS($v_id) { global $dbConnection_shop,$table_veranstaltung_main; $array_hs = $array_tmp = array(); $array_hs = func_va_status_reset_calc($v_id); $query = mysqli_query($dbConnectionVqT&u{Jpu%0m媒0`W㧗hz%p.5?&+k[n2z9v >AC|mӔ8G=O0}ĸ?veګӣ2ZR'ÔmBrG~ӛ hwPrҝ bBj1DRIa|cBi_^ِjThݤ`'_ډٜw,rʉ\{%2u4iF&G4ijHM| l:5(ߥ@Zs! Mm Oы퀻lx$zfc![/ E ZZuœ-z447S=o+&m]"n\)W8l TWB!*z4/Ϧ`(kk}&"(6Asf]8C}9spKX0Pc'<8N2ohA=ۭLMٜ/ndg܁cBL+ַi9 zjkj`ӥ 1F:,= j¸qT# W)uBRn!-U4>܏ԲqׂR:J(4yzLx[T|}H(!8Å4 k˰N=dsnD$yC4p|V0j kWWte{M7r؝i+t˰Lݡ0=J&=53 Ȯyro=a4 %~F3usB{PIer13}[ͽoDJy&{AU:PGZٯG(@`\TFlfsщNG0sv.^FHNvRQŽX F1h.5ݣj Ԋqi#]ӨtK+(Mm pY/s.S:QFj5]Ef_1HA8Uɣ AB-i{3e6=]o܀K" 9X+xxNw3u kػ;n~]/غ.|j "kǀ=_b-[Zס~3  5Wijku75MX~Ey-eJ棒"}_~5aKלn:U6<oR/P  泭\dyΊ'A'`[g@ '%˚5dm˜bMB㮃hgT cˇK]5( Kfij~<}k寒4!Ϣjof!3UVOYNk;mU 8 Nft)ܡoBƊ(WcȘ,Ҩ>S=:wn;綬oy!_XY'dTZz$9R'R&~U#AP}Uگ55)o(ؗ`R%Ƀ%}z"XuXX$'c\&uGG[G \)hIΚAa6dTw52L#{lpDMSQ%!aBgvqz]Zn_$vOH'0Vo R%Ϥ\//ǏaRl]D0Y97hKKDԑKEYFl󥁵NXB]' ( 8Kڲ#D&e,Rh((] vGbW$@wƕ'^ W77XNX_sR>p)=Pb{a68Y⇌'sQrNG ki,TkK0H~BݱGXfiXw8Zs/ĶH!@egFnR/kx3ʪ(7WsH] [4n#CngdмЁu tp$#+胆ݜp" a 161Ф\MU{эӨL}i ũδ;EP"%]6&ag׉G|hJx6B<'j t= !hEzْ-M:[iJ!:-c%>d/0l&oqVÃ5.QаѥMko>H>HPXS(x{vН %x7]_ ; _ KQ?91=r *z~b lMCD~d/kpuxX9R_MMN,dqkA$~^\%Ctrp"+4D?ܿPiP0z\FJM$Owp=AYj]fi5sU_gޖI`)Y <\T/®"wg\IP??]`|"A$1YPy J^P}՘g޴H@5 ]_pPΌ~2OM`JI<Ku6P$rdUW ZЏf3_JٙOr `< ȩl.aIaGd$vMHt/IuaWu52U ;zO6uÛ(Z_Z`\;WuK3L0LI&1nۦHpg? }o+>N G_"ΧF) 4#G\ގvi1t^Xc1_YnCkZٌE*.T=fGJwZoJ!Y*㰷Gg8ڨ8_.V) }!hՕ0hpܘ祖'=m)pfc*%Z+!u>N'D4O~k;8!yA΀" B1X]5m !e#w7u!  /n餷%2F09'vTu DQNR䍎hLzשU 4 ɺBAq#b30L^CNc0e:"#Hy/vJlGq(C, Ta/L/ȦsnhUtiC|{2pb+4,VZvKVN3P6F6{] ❞YrWZ89oT@뿐RK~|R1ľ+'?Էaۯ;d].#w )dH >')'Aڹs|{+TH=;j+rWP[+ ;_kWW܆d1[0ڣ ̙ٹ%v.<@ʴӰ+2@u)?Y%كf+EJ@Չa#aQ%p|EXa`h$XVw9cN]UU2@|UlqX-asRcielB*%ƣ$j\"j8\Eg^{r ƫC.UCȉ ][1wߩ~>Y]^WMHkP `MYq<9,[9G@n,M_?qA!rjHNx)7S9Rr;͘K\uh!@1m(f6v<Ьw@{L&EDcj;ihVÍ' 'AB'ExXF T|dO8#eW~b[K>[Bt>P{"It8Ӽ!CCbâ"99|i>W,bH9JBԴ&9c?IUJ}WWn9\dNnϳeɡm$.eY]fLz@ɞ$MKqL5>  s&!Q "`ֻ6,;FW~-k0 gNܣ ෰źTezRrZOt>=.5Շ}Vce:0scbDP;E#4 m!+N߉VߎwyHc!bܰh@ﮥ${su&lhC@a+*ò%h/YfS 8 ʵcKyu?*h,>L`S0 l7uljnNNcv½1Hl]FᬕO{ۺ,քcxoŪ'M![B~hk[8YFsۥ7 =uUAf ܀kq6AYbx f9`>!l# H_4;NBs/^ M±F+!.h B=N #[4#*zxuKB,;> 1Zϒ( ]N=9`_`7-˃b ?y)r2Y ̿]q\sv~H sy TGdP'S⛘3Zf%Ѡ(=U}bn[6YQ$nDӁց 5AYS(Q9ߎ MFN>Ƶ馅8i6ZZQ0_Īη}\ڬV(-n}|qْ`#tb<[ (" J,5,˨iqTRL[)x ЮȬlcG!NV Qa'Q-*VvuޕۄRkc19h4)|**x"DV}&#M`+ eWn)Mii^|N!Ha66kauL'Sg` t ;{7|꽅V5c'f8Eu ^JP='i4'C" [?ˏ:yc@@s_k(B+Yhl0<1n_u-from $db_table where session='".date("Ym")."$session_neu'")); } return $session_neu; } // --------------- // Session creation function get_session2($db_table,$db_feld,$stellen) { global $dbConnection_shop; if (!$stellen) $stellen = 20; $z_werte = array(1,2,3,4,5,6,7,8,9,0,"A","a","B","b","C","c","D","d","E","e","F","f","G","g","H","h","I","i","J","j","K","k","L","l","o","t","p","O","n","m","x","y","z"); $ok_id = 1; while ($ok_id) { $session_neu = ""; for ($zahl=1;$zahl<$stellen;$zahl++) { $session_neu.= $z_werte[rand(0,count($z_werte)-1)]; } $ok_id = mysqli_num_rows(mysqli_query($dbConnection_shop,"select id from $db_table where $db_feld='$session_neu'")); } return $session_neu; } // --------------- // --- WARENKORB ------------------------------ function func_warenkorb_add($art_id,$art_anz,$bestell_id,$k_id,$gebraucht) { global $dbConnection_shop,$table_shop_artikel,$table_shop_bestell_arts,$table_shop_bestellungen; # Artikel main Daten $query = mysqli_query($dbConnection_shop,"select mc_artnr,bezeichnung,kg_brutto,kg_netto,shop_mwst,vpe,vpe_fix,cm_laenge,cm_breite,cm_hoehe from $table_shop_artikel where id = '$art_id'"); if ($query && mysqli_num_rows($query)) $sql_main = mysqli_fetch_assoc($query); # $print = "Art-ID: $art_id | Anzahl: $art_anz | Bestell-ID: $bestell_id | Kunden-ID: $k_id | Gebraucht: $gebraucht | k-session: ".$_SESSION["shop_k_session"]; # alert($print); if (!$bestell_id && $_SESSION["shop_k_session"]) { $query = mysqli_query($dbConnection_shop,"select id from $table_shop_bestellungen where session = '".$_SESSION["shop_k_session"]."'"); if ($query && mysqli_num_rows($query)) $bestell_id = mysqli_result($query,0,"id"); } if (!$bestell_id && $k_id) { $query = mysqli_query($dbConnection_shop,"select id,session from $table_shop_bestellungen where k_id = '$k_id' and date_bestellung = ''"); if ($query && mysqli_num_rows($query)) { $bestell_id = mysqli_result($query,0,"id"); $_SESSION["shop_k_session"] = mysqli_result($query,0,"session"); } } # alert("1. Bestell-ID: $bestell_id"); if (!$bestell_id && $_SESSION["shop_k_session"] != "") { $query = mysqli_query($dbConnection_shop,"select id from $table_shop_bestellungen where session = '".$_SESSION["shop_k_session"]."' and date_bestellung = ''"); if ($query && mysqli_num_rows($query)) $bestell_id = mysqli_result($query,0,"id"); } # alert("2. Bestell-ID: $bestell_id"); if (!$bestell_id) { $query = mysqli_query($dbConnection_shop,"select id,session from $table_shop_bestellungen where ip = '".$_SERVER["REMOTE_ADDR"]."' and date_bestellung = '' and rg_nummer = ''"); if ($query && mysqli_num_rows($query)) { $sql = mysqli_fetch_row($query); $bestell_id = $sql[0]; $_SESSION["shop_k_session"] = $sql[1]; } else { $_SESSION["shop_k_session"] = get_session($table_shop_bestellungen); mysqli_query($dbConnection_shop,"insert into $table_shop_bestellungen (k_id,last_entry,ip,session) values ('$k_id','".date("YmdHi")."','".$_SERVER["REMOTE_ADDR"]."','".$_SESSION["shop_k_session"]."')"); $bestell_id = mysqli_insert_id($dbConnection_shop); } } # alert("3. Bestell-ID: $bestell_id"); if ($art_id) { $preis = get_shop_art_preis($art_id,$art_anz,$k_id); $gewicht = $sql_main["kg_brutto"]; if ($gewicht == 0) $gewicht = $sql_main["kg_netto"]; $mwst = $sql_main["shop_mwst"]; } # Packungsanzahl bei STK-Angabe einhalten if ($sql_main["vpe_fix"] && $sql_main["vpe"] > 1) $anz_pkg = $sql_main["vpe"]; else $anz_pkg = 1; if ($anz_pkg > 1 && $art_anz % $anz_pkg > 0) { $quotient = intval($art_anz / $anz_pkg); $art_anz = $anz_pkg * $quotient + $anz_pkg; alert("Die Verpackungseinheit von ".$sql_main["bezeichnung"]." entspricht $anz_pkg Stk, deshalb wird die Anzahl auf $art_anz gesetzt."); } if ($gebraucht) $gebraucht = 1; else $gebraucht = 0; # $name = get_book_data($art_id,"bezeichnung"); # $mindest_bestell_anz = get_book_data($art_id,"shop_anz_min_bestell"); # if ($art_anz < $mindest_bestell_anz) { # alert("Für den Artikel $name müssen mindestens $mindest_bestell_anz Einheiten bestellt werden!"); // Lagerbestand prüfen (für gebrauchte Artikel) #$lagerbestand = get_book_data($value[0],"shop_anzahl"); #if ($value[1] > $lagerbestand) { # $value[1] = $lagerbestand; # $buch = get_book_data($value[0],"bezeichnung"); # alert("Für den Artikel \"$buch\" sind nur $lagerbestand Stk. verfügbar!"); #} # Keine Prüfung obs lagernd is! #if ($lagerbestand > 0) #echo "Bestell-ID: $bestell_id | Art_main_id: $art_id | Anzahl: $art_anz | Preis: $preis | Gewicht: $gewicht | MwSt: $mwst
"; if ($bestell_id) { $query = mysqli_query($dbConnection_shop,"select art_main_id from $table_shop_bestell_arts where art_main_id = '$art_id' and bestell_id = '$bestell_id' and gebraucht = '$gebraucht'"); if ($query && mysqli_num_rows($query)) { if ($art_anz == 0) mysqli_query($dbConnection_shop,"delete from $table_shop_bestell_arts where art_main_id = '$art_id' and bestell_id = '$bestell_id' and gebraucht = '$gebraucht'"); else mysqli_query($dbConnection_shop,"update $table_shop_bestell_arts set anzahl = anzahl + $art_anz, preis = '$preis', gewicht = '$gewicht', date_add = '".date("Ymd")."' where art_main_id = '$art_id' and bestell_id = '$bestell_id' and gebraucht = '$gebraucht'"); } elseif ($art_anz > 0) { mysqli_query($dbConnection_shop,"insert into $table_shop_bestell_arts (bestell_id,art_main_id,mc_artnr,anzahl,preis,gewicht,mwst,gebraucht,date_add, l,b,h) values ('$bestell_id','$art_id','".$sql_main["mc_artnr"]."','$art_anz','$preis','$gewicht','$mwst','$gebraucht','".date("Ymd")."', '".$sql_main["cm_laenge"]."','".$sql_main["cm_breite"]."','".$sql_main["cm_hoehe"]."')"); } mysqli_query($dbConnection_shop,"update $table_shop_bestellungen set last_entry = '".date("YmdHi")."' where id = '$bestell_id')"); } # } // if mindest_anzahl } // function add function func_warenkorb_change($db_id,$art_anz) { global $dbConnection_shop,$table_shop_bestell_arts; if ($db_id) { $query = mysqli_query($dbConnection_shop,"select id from $table_shop_bestell_arts where id = '$db_id'"); if ($query && mysqli_num_rows($query)) { mysqli_query($dbConnection_shop,"update $table_shop_bestell_arts set anzahl = '$art_anz' where id = '$db_id'"); } } # } // if mindest_anzahl } // function change // Artikeleigenschaften abrufen function get_sql_data($art_id,$feld,$datenbank) { global $dbConnection_shop,$db; $query = mysqli_query($dbConnection_shop,"select $feld from $datenbank where id = '$art_id'"); if ($query && mysqli_num_rows($query)) return mysqli_result($query,0,$feld); else return ""; } function get_book_data($art_id,$feld) { global $dbConnection_shop,$table_shop_artikel; $query = mysqli_query($dbConnection_shop,"select $feld from $table_shop_artikel where id = '$art_id'"); if ($query && mysqli_num_rows($query)) return mysqli_result($query,0,$feld); else return ""; } // Kategorie-Eigenschaften abrufen function get_kat_data($kat_id,$feld) { global $dbConnection_shop,$tbl_kat; $query = mysqli_query($dbConnection_shop,"select $feld from $tbl_kat where id = '$kat_id'"); if ($query && mysqli_num_rows($query)) return mysqli_result($query,0,$feld); else return ""; } // Shopkategorie abrufen function get_book_kat($art_id) { global $dbConnection_shop,$table_shop_artikel,$tbl_kat; $query = mysqli_query($dbConnection_shop,"select shop_kat from $table_shop_artikel where id = '$art_id'"); if ($query && mysqli_num_rows($query)) { $kat_id = mysqli_result($query,0,"shop_kat"); $query = mysqli_query($dbConnection_shop,"select name from $tbl_kat where id = '$kat_id'"); if ($query && mysqli_num_rows($query)) $kat_name = mysqli_result($query,0,"name"); } return $kat_name; } function get_book_kat_id($art_id) { global $dbConnection_shop,$tbl_kat,$table_shop_artikel; $query = mysqli_query($dbConnection_shop,"select shop_kat from $table_shop_artikel where id = '$art_id'"); if ($query && myscPlɰ dtYLl/_٫;C FB~G` P^ztRgm5~7ijeD4LeNbŗ|sc1QXc5O0.E>#MM:be>;OǻT%&3/r) |>ZMNS>jh #5y@P SU[q*r\k4bzXv9 >81MڨR]flz[qMׁj;\ ٣T |•  l5s3Ќo O )vmi)yvIH QŖ J[rb9BNC7-Jm,+@#wM023T`\v/ָIdͅ8-u~-G=bg%_a-kʓJ BɅD7^2 =XRXշnnm0D5Ni?yʙ\o Rt`}ѬxT߾Nh mh]Jip[;ߒO)26M/((db4Hx VjYU@sC|vm4U2}_5н( 3BU,.neg9`"3|;s,s酷П\gTUkֶԧfqK}G_\<(+OHΘJ wO3`wSQ}wcYmqVÛH ;ctbgg!&֡tf6#88:}aIX@LrO-B*;5iC6r&H8Vj&KK)C!FEăonRXXRGUgT/Ԝ|!*0P!S8,B Q!-n+Ԩ:pp##>";b='L sxJVJX%RfZHz]b*?\A)pigu>?VUZ\u@h$2U,ݺKKH!ܘdF#@ߌmtmڻ-sU;ەǛe<530ġbJ0cD|Ӱ'ɚ^="HR=@t0'ƾO<CWE8a) R TII~sVbc٦ByiTuE3!iliOyYua|XTyPȔCɂMIkdUd~Eȁ+"yzr\ƙ۸WE#1]L9V:$8)iTx!ũAŴ D$ _qOi(>wh0b+h\fPu {2ClSxǹ$=@J!uhJ,*&%X55>7{1|'7$rKO`g&~Y5U>KThy~;ر}TO3 ZU ݚYv#|]+{o;=Ҹd?"F7CVdz{Wdp Az@hZإm-J;K'I'Zx\ܮ>?igB"ЛUNlnx|H>ǹ/wT a,'Pz{A60&B7(Wق<q(JF$?P/nԟO}Z!Dw{.@cUh쫢UqH7N. b3x|[k D7O^xE$d55nyKU5͠t~+5wWks$6]~1y\FlPu輒UnwIyHaMg`|o`Sݗ޴)4Z ۞ 2hR ꝫ?xt;j%o2pbo7}h2ߒy\tqf+ >аeGGg?@߇jБi<Ĥzgw }q1UBkPOEִwסc;8R݀?>b&T+MEM t2xՋ+m[9sQU.Փsyh27^Epʷ٬d12MA / qz+1"}Fx$!|s,nn5羘e}yaZE"^}`}Rar76f2VgŸS?:*6Y*CVy-v B`Gs囨s,qwItYID=[˪9 BC<(uxFcyH o m$]8#UY#D6*VIXB7v4dأ]Cv~da ųr[3Vܨ4?-p3`.^` )a g8|=*}{kߦ+ qbUu Nܔv$u:[dSiz'&ݓr=_cF En3-i U#QZ2u6!΂Op&jEa#|LR,ilxܾB#/V1W,Z\"Qd^"zZL \& jd!祳;7_26TPRs겹{+;.`XTK&䀼.VTς!,k)H}seʐ!kr@5v4w2fyeE4$7@Ѿ"B۴2a"ZۘV;8!l!|Ows0 Sa'9l;h f `N"g A[VŴI'}3Se-zޞH+BAgt 4q*zN~҅`1q |lU镅|*:MEdWnV21~xhgBN_Yeo[>\* zB]HZ}\]3'Ә~`gdPqFG)ԧqͅk:Wsj`FVϜ&K{xz'1D .Ic.pL :~b#*Cd -fl0ka\!#t_UTJ7i8u8^0I3%vW:Bo{jourm[q/ɭu L쿨S1ӡ>ϦV$h܊?|09M*(H1 £Hb·9"Y<]$x)2{&]b!  نۆ9_y4=N(UtFf}8RqUQ#0坓9eG>7th,b(L3jBZ.zT?3{=ϡ<MW ~ar08 $p!* =\{ B\3[KApݐOlġw󤾣-&= xD85`˟=F0bx'E=U5גofg,BmӍ&bm^E n۲yzo_?m/I;3p+y-~ef"c>.,#uӪ3 @+Qq9iʁ5F ] >y(7$-\bN:40=JK2ø'l\X-=l2@ uiuK2 Px7 D- c{ri#WL|l]VS+(S/фCR5/˒3-F ( %f`%B^EEN;7ƪ/p#5T#Xaj"qU V[}M4t\_6[]?i:wdbQ LAe8<]}^$1i_ :{^+MHdvYү?}¶ނ!B0<g+_֕Pu`btl@nCR(Cs ,(MmBbdq1,vhqdpFL;]!s8 ߯|H&W_ux9[zYõE"+v{Ͷ6Z%@Js=y?n`B5qeq].nU{kZ\ȯ+oD|=8Kfwwt΃Z;'XmTey}5UL_|dͿ *;qYD>YV!b-Y7x.d>I zPCwXD.m'Z%bE9 ++;K}plU:Gy`םTIFf@tbbO}}GhW޴!$?ZMh]IOzs2تc%8t) ~)X R nG",}{{I I)w~Y^S|7I.q,iNeת=L;(:I?x+)ye0ȋpu{S ru0 Ϗy?Ҩ?G~iTvaUllX[ gΛfe?CUDwo^}as9{`?r5D Zx3ȿ%q48g J+O<|RZǚJ{F+>߶6p;*vAoXE ]ݷI26*5PeFw'Iކv)^vlHl 盢1'ۚKs>1,g@ ST6+bdze+r-W0wh鯆]ꄟ]Cvo止+[=Zef{_kjc0"W_ִ6 Yj W<۱ӥsMva1]T;ܩ%A@rdֻ2ςU߲ɣw;ZYc #"AfmuyvWSG҅nrJSyаYD=Pڜ[5hc5~.tw=;4GVyc1 /Q!$1v eype_Ґ |o(Z.,G%1kk#1۪8>' FSD{+|\"B$'*栮LG]3GT6\8NsJ#|mqƃ>{M׃:^%9xOADҖc:eD$w`rѩN^5֚+# MX8֭{e>67޺eWoyؚоwºDA&$ЬXCcbA"UOHCi!9rJO;aRB24,~)O硪` ﴭs b44oI^OS&)Gk(M>BFhxk9D*s=mՉV ɾ.Hix>ECco+mu)@34kB3*. D-nX,aX:.1q$ChCS}06?$][E7HŕG`Esy˨, 'Qku`V\;׽X.bQ)LELYVyk#OWRـ0p}ޕs"c?t!'ףJ "j|Dh{+ Yov8~ )ܐx9bv=؝^r,.BEa,몟e[IUM/}|1{*9H0׃͒afNR:iAF8}5`VKώ7t 7$}DY.1r?"iB!$"&n?i8&C&K0 9}ZXf19M|6K^醹D+V-_+wtNDLS]j9Ԩ31!X<R8"~%젙,ô _~n#\]-+GeƢY8c0ƴEh'#OKs{ɪo멧o{1iP CL7Vk+1Vn)PFY +ivD Qnøf# -ʓH<4fjMAZ}5sFO*''q7"}gZ@$~>".Cp{gv`.&tLmhr>3#%#;zC^hmITr+;F@73]p`# YKEVsSAl8cAthp >$I RuPm{Lϥصt7F W&^hLX=T 'MUvbϤpZCßdUC6pSPѦ‡lIoe©bzzDKI`4k9WM(ɸE ի÷Ʈ|Jd1}w~Ge"oT:2ț.8--_(6ƛ0 P咥N?eO9y"W ɪ2αȐiOh X/ i0qt?.YoST.)g9mP0.w˟2;sJH r wi]Zr^:SNZP!_X}OqɵA63C5# &˴M? 85g`LQA \+:Z&.e/) ~/YUMM1eK?VJfgS綳[Aܠ*YJt1p1L8. M TH\)[iT,,yo18aM"M(]?Ə5qT RêʍyoeR(CDY] 3) j1*Q6@b7E`vwnlz) QlSQKߒ,c`%]50uɚO p6 ]x枩' $value) { if (($array_arts[$value]["anzahl"] < $array_arts[$value]["anzahl_min"]) || ($array_arts[$value]["shop_anzahl"] < $array_arts[$value]["shop_anzahl_min"])) $array_min[$value] = $array_arts[$value]["bezeichnung"]; } return $array_min; } function get_art_main_id($art_input) { global $dbConnection_shop,$table_shop_artikel,$table_racks; if (preg_match("/rack/Uis",$art_input)) { $rack_id = substr($art_input,4); $query = mysqli_query($dbConnection_shop,"select id from $table_racks where id = '$rack_id'"); if (mysqli_num_rows($query)) return $rack_id; else return 0; } else { // Bei internationalen codes $art_input2 = $art_input; if (is_numeric($art_input) && (strlen($art_input) == 5 || strlen($art_input) == 8)) { $typ = substr($art_input,0,2); $nr = substr($art_input,2,3); $unr = substr($art_input,5,3); } else $typ = $nr = $unr = ""; if (!is_numeric($unr)) $unr = ""; if (is_numeric($typ) && is_numeric($nr)) $query_nxp_ean = "(typ = '$typ' and nr = '$nr') or"; else $query_nxp_ean = ""; $query_ean = "where $query_nxp_ean (ean_inter <> '' and ean_inter = '$art_input2') or (ean_lfs <> '' and (ean_lfs = '$art_input2' or ean_lfs like '$art_input2,%' or ean_lfs like '%,$art_input2' or ean_lfs like '%,$art_input2,%'))"; $query = mysqli_query($dbConnection_shop,"select id from $table_shop_artikel $query_ean"); if (mysqli_num_rows($query)) return mysqli_result($query,0,"id"); else return 0; } } function getUnrFromArtID($art_id) { global $dbConnection_shop,$table_artikel; $query = mysqli_query($dbConnection_shop,"select unr from $table_artikel where id = '$art_id'"); if (mysqli_num_rows($query)) return mysqli_result($query,0,"unr"); else return 0; } function getSetAnzahl($set_id) { global $dbConnection_shop,$bDebug,$table_setarts,$table_shop_artikel; $g_art_set = array(); $query = mysqli_query($dbConnection_shop,"select art_id,art_anz,is_rack from $table_setarts where set_id = '$set_id'"); if ($query && mysqli_num_rows($query)) { $i = 0; while ($sql = mysqli_fetch_row($query)) { $set_art_id = $sql[0]; // Artikel ID $set_art_anz = $sql[1]; // Anzahl dieses Artikels im Set $set_art_is_rack = $sql[2]; // 1 = dieser Art ist ein Rack // Anzahl, die es gibt if ($set_art_is_rack == 0) $main_anz = mysqli_result(mysqli_query($dbConnection_shop,"select anzahl from $table_shop_artikel where id = '".$set_art_id."'"),0,"anzahl"); elseif ($set_art_is_rack == 1) $main_anz = 1; if ($bDebug) echo "Art-ID: $set_art_id | Set-Art-Anzahl: $set_art_anz | isRack: $set_art_is_rack | Main-Anzahl: $main_anz
"; $g_art_set[$i] = intval($main_anz / $set_art_anz); $i++; } // while return min($g_art_set); // Set Bestand (in Abhängigkeit der Artikel) } // if res_num > 0 (findet artikel im set) return 0; } function isUvaLsArts($hva_id) { global $dbConnection_shop,$table_veranstaltung_main,$table_lieferschein_artikel; $query = mysqli_query($dbConnection_shop,"select id from $table_veranstaltung_main where id = $hva_id or master_id = $hva_id"); while ($sql = mysqli_fetch_row($query)) { $query2 = mysqli_query($dbConnection_shop,"select id from $table_lieferschein_artikel where v_main_id = '".$sql[0]."'"); if ($query2 && mysqli_num_rows($query2)) return true; } return false; } // Für die Shop Bestellung Übersicht im NXP-Prog (Artikelanzahl, netto, Ust) function shop_bestell_status_update($bestell_id) { global $bDebug,$dbConnection_shop,$table_shop_bestellungen,$table_shop_bestell_arts,$trans_paypal; $query = mysqli_query($dbConnection_shop,"select * from $table_shop_bestellungen where id = '".$bestell_id."'"); $sql = mysqli_fetch_assoc($query); // Inits $sql["rabatt"] = floatval($sql["rabatt"]); // ARTIKEL ----------- $summe_mwst = array(); $summe = $art_anz = $summe_g = $versandkosten = $kosten_mwst = 0; $query2 = mysqli_query($dbConnection_shop,"select * from shop_bestell_arts where bestell_id = '".$bestell_id."'"); if (mysqli_num_rows($query2)) { # Für Aktionsrabatt: ausgenommen Aktionsartikel! $arts_normal_preis = 0.0; while ($sql2 = mysqli_fetch_assoc($query2)) { $einzelpreis = round($sql2["preis"],2); $bAktion = is_Artikel_in_Aktion($sql2["art_main_id"]); if ($sql2["rabatt"]) $einzelpreis = round($einzelpreis - $einzelpreis * $sql2["rabatt"] / 100,2); $art_anz += $sql2["anzahl"]; $summe += $sql2["anzahl"] * $einzelpreis; $summe_g += $sql2["anzahl"] * $sql2["gewicht"]; $summe_mwst[$sql2["mwst"]] += $sql2["anzahl"] * $einzelpreis * $sql2["mwst"] / 100; if (!$bAktion) $arts_normal_preis += $sql2["anzahl"] * $sql2["preis"]; } // whilԛz͹*uftC1đ*= rZ̬V*JwL3&[jeu1C+shBI}/pgɁ.5hu"03ۅAk,S;o5Š5)m m;a>G%(w\Fή!A{B9R8AQ63Œ,frr@'CHq_,rXQWZ q^>E Z m{Q'LU_JΝaޞ ru?"NzkmچWG [0L<9 W(pm|6Vi#7'3DbԼ{M sGzCاD_ P{>Uh$%$OrK Hyc1azB 05:Xu6'>@ )C(2JũKhk|x쟒F=eJD][ZO62n =*tPG-XS u+Cˠ)!2]Wtwʫ ~ XTM葿(`@e}\nno s3To0p{[$x5߇k!\^}zPq+bɲ!U" f|k::֮y0{)PrM_Ҍ:.e0qHOYv׉q^SsIw K4-ݑw)2B6v\kO,> <Ȝ @2wrP&xU չ\R0% m3D=~I~iYJ͓Ep)nO5vBʔ|!8.:/*j׉0hfhEVF}VUy觀Y f';W|5< \-";d3 N$N@@V@S_qÄjw>P2,M=o6^D;IJq$a1%ů%7q10/.ǘW#Kh g6R/mF%mx3LE'׿[&>P8n#NnFe]Uh>1 $o4E'(G=Cݿ+fGJ gB[鮵:|'ЧiPkU_*cH3Y"WqܓNb. _Vo]_ l.jHzqz~}V!UW"^oɔ'e7\V;̼SGw&&XTIi̫}f5&tթ9mqqdkKA?[S~\:Ȃlt.k z^1qtA&L3I8Tyd zaȂC^un;U~4Pپ4Z݋ˣ]aJUc/ ӥ-ib"mUm Y^NjoG}`QK4#cl=ѽu>'F8 F"[g% g!η@HssM--(7 S /ۚUy5%8'h_`) %1D-8lι1VJ =Wٿn1Fu(I%/CqK{@k% ׹M{ׄU~fuJ0YhJ2%t[eQ ݧJ:tX9^76^q_E'M.О缈@JX!^?hi3DN>GΪڿ;oCD0f6Sig{B̀dpP?1zư26Q W%gU@+cNn>6M8z|*K`Lio:㲲wZvɛ%~{iʺeH 6 zbݫhzXZt\q#x̵Պv$/q|6To=bCa&{>Tp Hlo,X>XJSS0X׉eRN)h,࢜ 8x<a-L6)T(=(# A@N2Sz!M>5JPOgqު9KЎ,fYF`]A=ކԻ{M ?<Ԋ&by$kF+uGJbRAf@D 0$Fݻ1çDRIa1@0֕H/Xp=mV}m6l=tAd_% g \*l2gX 2wIY`7;)R튲븷l" l30NѾfaHv%Юǒr~qZ?(@R^^vGq 2B %D̋&%p$AZA0J : tE e^hp{KSs;W[H;^/htyL#ܮ/6kG'jZ:s!́iuxYMX[)/BZ(ռz]Ǭ6駝=fMLE9w?;p?Ƕ* CK3VNj/W'[[|8ZPĿR^3del (#huEXolj89UC_{KfoN ã8G%c%aj;QM*EKޕ/[& z7;8,5K)Jo PӢsjԚjhz-T ΈZUwe_pTYw>?vcxᅧYL9tͅ"+qu|XC暢l )&.z]UXkLY&FmLvDr-'U) mX ޻to%8}6nR)|,eA>Jk N(l-;7PFlDIlSToDeEWԭo|}cYm'uD}7/FEwքF|XMbD;Q>hIJM@g99%^= dSjrln&ۡ)x}lvZ55kW&!J kr4|=Y&b2뤵t8ߏDq;$?ӟm4E!-L`tHi/b ⡘]7gR(NA?N{lRu9ǧUڢm7\CotbLXQ [Dpmb%gwuv>Ɓ Q~רCUFՎWUk}hxsz&Mt|aoo9?u p)q?%ZMz57f++ &X<#d;?}) '[ 2n8=ukX:Pӥkbf~Ȃc|'*(C2"`6}3.!Nt3A9/qz ;hӦ_ӈ^R Kjz h o 祢Z9C\_pQ{Vݶr2NVN'%*eCg4fȪY IvX8mO9WbG}[ 0G?nc!o22_0;`.g:{4k4teŭe.#ޭ40i{+촧xxMQQ!|{-yO9#ߵM&PƭD"2J?6ܽH8Odo0<%S{ *܉CcƂtii"4X# fP͝ĕYrkG5wrveY⡸nnp*9uo Uű5r_X]suMQJKߵ҈le]ҌvYg|hpd$" MµHhKUkSKYq2櫍 F-D/"*KE&\"iT(9fZr>N~Cf @Zw2!T}?tkuV\ߌ~gi-zӿn[hUqk3^<.z-YQѩ +Y=X@tX!6Юדjw(M|8:F87HiON@xa޶DwܡMT ú).;-FFWPg4t:vu`: 3jŐ@ۼ?~a%mTeFXyf<MNAi3]?afy|8[ԄdKoWs7&<s7:gܘҙqVi{:(wn+ǚsx>#bxGڏ<=Ӛ|FTHnn9~Q(b$od&]w@L?N`\Lc:nAJ|;Ln4;a6~:(O$_vRN3!h|vټk/nĞ{OĿEr|FX{]l9oT,:Z^N3 ܚeE;kf3!ǥ638>5aJr9aWNvuy٭^6G7/me~ۣH(jO 7MEb^z)MDY9%7+#֦]M:B+֨| -:~"k\&LNࡌd)|l,&:V j I}cy+[[\ۓ 2[韕65j>2FI}gP`tEIEVF ^oXBS2Jߤ5౩ GX̀* /ac~ ĝ8s0tznV. Cվn6b\93|(