/**
* 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 refreshTipo($request, $id)
{
$db = new DBAL();
${$id} = $db->update("tipo", $request, $id);
return self::find($id);
}
public static function refreshUsuario($request, $id)
{
$db = new DBAL();
$id = $db->update("usuario", $request, $id);
return self::find($id);
}
public static function refreshMedida($request, $id)
{
$db = new DBAL();
${$id} = $db->update("medida", $request, $id);
return self::find($id);
}
public static function refreshProduto($request, $id)
{
$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->update("produto", $request, $id);
return self::find($id);
}
