function update($type, $type_id, $content)
{
global $db;
$content = $this->chinese_words($content);
$sql = make_update_sql($this->table, array('content' => $content), array('type' => $type, 'type_id' => $type_id));
return $db->query($sql);
}
function update($id, $data = array())
{
global $db;
check_allowed(str_replace(LZ_MYSQL_PREFIX, '', $this->table), 'update', LZ_RESPONSE == 'text');
$sql = make_update_sql($this->table, $data, array($this->id => $id));
return $db->query($sql);
}
$dbarr['date'] = date('Y-m-d', strtotime($update_date));
$dbarr['time'] = date('H:i:s', strtotime($update_date));
$sql = make_insert_sql("{$tablepre}book", $dbarr);
} else {
$dbarr['update_date'] = $update_date;
$dbarr['item'] = $item;
$dbarr['item_txt'] = $item_txt;
$dbarr['remark'] = $remark;
$dbarr['ccy'] = $ccy;
$dbarr['amount'] = $amount;
$dbarr['net'] = $net + $amount;
$dbarr['otype'] = $otype;
$dbarr['date'] = date('Y-m-d', strtotime($update_date));
$dbarr['time'] = date('H:i:s', strtotime($update_date));
$where['id'] = $id;
$sql = make_update_sql("{$tablepre}book", $dbarr, $where);
$edit = '修改';
}
mysql_query($sql) or die(mysql_error());
if (mysql_affected_rows() == 1) {
if (mysql_insert_id()) {
$id = mysql_insert_id();
}
showmsg("{$model_name}{$edit}成功！", '成功', "../view_book.php", '返回');
} else {
showmsg("{$model_name}{$edit}失败或没有修改！", '失败', "return", '返回');
}
exit;
}
$sql = "SELECT item_txt FROM {$tablepre}book WHERE uid={$uid} GROUP BY item_txt";
$item_txts = $db->fetch_all($sql);
