Internet JPK wrote:
> Internet JPK wrote:
>
>> Witam!
>>
>> Coś jest ostro namieszane z wpłatami...
>> Nie mogę dodać wpłaty klienta !! Robię to tak:
>> 1. Otwieram kartę klienta
>> 2. Wprowadzam wartość operacji (kwotę)
>> 3. następnie wprowadzam opis operacji
>> 4. klikam "zapisz"
>> i nic !!
>> nie ma tej wpłaty !!
>>
>> Co robić ???
>>
>>
> Problem jest w przecinku !! Kropka lub przecinek blokuje wprowadzenie
> wpłaty !!
> Czy jak dodam ręcznie do bazy w tablei casch (lub poprawię) to będzie
> ok ??
>
Witam!
Dziwię się, że nikomu ten błąd nie przeszkadza ! Dziwię się też, że
nikt nie może powiedzieć, czy wpłaty są tylko odnotowywane w bazie cash ! ?
Poniżej poprawka usuwająca zgłoszony przez ze mnie błąd !! (przygotowana
przez .PaKud 'a)
2094,2095c2094,2095
< {
< $this->SetTS('cash');
---
> {
> $this->SetTS('cash');
2098c2098
< return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?, ?, ?, ?, NULL, ?, ?, ?, ?)', array($addbalance['time'], ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], round($addbalance['value'],2), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0 ), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
---
> return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?, ?, ?, ?, NULL, ?, ?, ?, ?)', array($addbalance['time'], ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], str_replace(",",".",round($addbalance['value'],2)), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0 ), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
2100c2100
< return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array($addbalance['time'], ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], round($addbalance['value'],2), round($addbalance['taxvalue'],2), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
---
> return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)', array($addbalance['time'], ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], str_replace(",",".",round($addbalance['value'],2)), str_replace(",",".",round($addbalance['taxvalue'],2)), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
2103c2103
< return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?NOW?, ?, ?, ?, NULL, ?, ?, ?, ?)', array( ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], round($addbalance['value'],2), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
---
> return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?NOW?, ?, ?, ?, NULL, ?, ?, ?, ?)', array( ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], str_replace(",",".",round($addbalance['value'],2)), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
2105c2105
< return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?NOW?, ?, ?, ?, ?, ?, ?, ?, ?)', array( ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], round($addbalance['value'],2), round($addbalance['taxvalue'],2), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
---
> return $this->DB->Execute('INSERT INTO cash (time, adminid, type, value, taxvalue, userid, comment, invoiceid, itemid) VALUES (?NOW?, ?, ?, ?, ?, ?, ?, ?, ?)', array( ($addbalance['adminid'] ? $addbalance['adminid'] : $this->SESSION->id), $addbalance['type'], str_replace(",",".",round($addbalance['value'],2)), str_replace(",",".",round($addbalance['taxvalue'],2)), $addbalance['userid'], $addbalance['comment'], ($addbalance['invoiceid'] ? $addbalance['invoiceid'] : 0), ($addbalance['itemid'] ? $addbalance['itemid'] : 0) ));
ps.: podobno jest więcej tego rodzaju błędów ale to może być złudzenie...
--
pozdrowienia
jpk
