/** * saves a user object from memory to Database. * * @param User $user * * @return bool */ public function save(User $user) { /* $data keys should correspond to valid Table columns on the Database */ $data = array('userid' => $user->getUserId(), 'username' => $user->getUsername(), 'email' => $user->getEmail()); /* if no ID specified create new user else update the one in the Database */ if (null === ($id = $user->getUserId())) { unset($data['userid']); $this->adapter->insert($data); return true; } else { $this->adapter->update($data, array('userid = ?' => $id)); return true; } }
public static function persistTipo($request) { $db = new DBAL(); $id = $db->insert("tipo", $request); return self::find($id); }
public static function persistEntrega($request) { $db = new DBAL(); $request['qtEntrega'] = str_replace(',', '.', $request['qtEntrega']); $id = $db->insert("entrega", $request); return Entrega::find($id); }
public static function persistPedido($request) { $db = new DBAL(); $itens = array_remove($request, 'itens'); $request['idPessoa'] = $request['idPessoa'] ?: null; $request['idUsuario'] = $_SESSION['usuario']['idUsuario']; $request['vlDesconto'] = $request['vlDesconto'] / 100; $id = $db->insert("pedido", $request); foreach ($itens as $key => $val) { $itens[$key]['idPedido'] = $id; } $ids = $db->insertMultiple("item", $itens); return self::find($id); }
public static function persistMedida($request) { $db = new DBAL(); $id = $db->insert("medida", $request); return self::find($id); }
public static function persistMaterial($request) { $db = new DBAL(); $id = $db->insert("material", $request); return self::find($id); }
public static function persistPagamento($request) { $db = new DBAL(); $days = $request['qtPeriodo']; $request['dtPagamento'] = date('Y-m-d', strtotime($val . " + {$days} days")); $request['vlPagamento'] = str_replace(',', '.', $request['vlPagamento']); $id = $db->insert("pagamento", $request); return Pedido::find($request['idPedido']); }
public static function persistProduto($request) { $db = new DBAL(); $request['vlCompra'] = str_replace(',', '.', $request['vlCompra']); $request['vlVenda'] = str_replace(',', '.', $request['vlVenda']); $request['vlKGMT'] = str_replace(',', '.', $request['vlKGMT']); $request['vlKGPC'] = str_replace(',', '.', $request['vlKGPC']); $request['vlMTPC'] = str_replace(',', '.', $request['vlMTPC']); $request['qtMinimo'] = str_replace(',', '.', $request['qtMinimo']); $request['idPessoa'] = $request['idPessoa'] == "" ? null : $request['idPessoa']; $id = $db->insert("produto", $request); return self::find($id); }
public static function persistQuimica($request) { $db = new DBAL(); $id = $db->insert("quimica", $request); return self::find($id); }