/**
* 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);
}
