function SetCustomerAccessByBalance($id,$balance) { $blokada = $this->DB->GetAll("SELECT access,warning FROM nodes WHERE (access=0 or warning=1) AND ownerid=?",array($id)); if (sizeof($blokada)>0) { # sprawdzamy bilans jesli 0 to odlokowujemy i wychodzimy $bilans = $this->GetCustomerBalance($id); if ($bilans >= 0) { $this->SetAccessToOnForCustomerNodes($id,$balance); return TRUE; } # sprawdzamy ostatnia fakture jesli bilans = fakturze i nie uplytnal termin platnosci - odblokowujemy i wychodzimy $lastinvoice = $this->DB->GetAll( "SELECT sum(invoicecontents.value*invoicecontents.count)*-1 as value, id, cdate, cdate+(paytime+1)*24*60*60 as pdate FROM invoicecontents LEFT JOIN documents ON documents.id = invoicecontents.docid WHERE documents.customerid = ? AND documents.type = 1 GROUP BY id ORDER BY id DESC LIMIT 1;",array($id)); if(isset($lastinvoice[0]['value'])) { if($lastinvoice[0]['value'] == $bilans && $lastinvoice[0]['pdate'] > time()) { $this->SetAccessToOnForCustomerNodes($id,$balance); return TRUE; } } } return FALSE; } function SetAccessToOnForCustomerNodes($id,$balance) { $this->DB->Execute("UPDATE nodes SET access=1, warning=1 WHERE ownerid=? AND access=0",array($id)); $message = "

Dzi��kujemy za wp��at��.

Informujemy, ��e w dniu: ".strftime("%d.%m.%Y",time()). " zaksi��gowali��my wp��at�� w wysoko��ci: ".$balance['value'].'z��'. ".
Po naci��ni��ciu przycisku poni��ej - strony internetowe zostan�� odblokowane."; $this->DB->Execute("UPDATE customers SET message = ? WHERE id=?",array($message,$id)); }