/**
* 删除分类
*
* @param string $cid 分类ID
*
* @return void
*/
public static function delete($cid)
{
$hasChildren = Local::fetchOne('SELECT COUNT(1) as total FROM z_account_cats WHERE cat_parent=:cat_id', array(':cat_id' => $cid));
if ($hasChildren['total'] > 0) {
echo '{"code":"1", "msg":"该分类下还有分类,请先删除子分类."}';
exit(0);
}
$statement = Local::query('DELETE FROM z_account_cats WHERE cat_id=:cat_id', array(':cat_id' => $cid));
$statement->closeCursor();
}
/**
* 更新账户信息
*
* @param array $data 要更新的数据
* @param int $id 数据ID
*
* @return void
*/
public static function update($data, $id)
{
$sql = 'UPDATE z_accounts SET ';
$inputParams = array();
foreach ($data as $k => $v) {
$sql .= "{$k}=:{$k},";
$inputParams[':' . $k] = $v;
}
$sql = substr($sql, 0, strlen($sql) - 1) . ' WHERE account_id=:account_id';
$inputParams[':account_id'] = $id;
$statement = Local::query($sql, $inputParams);
$statement->closeCursor();
}
