/** * 删除分类 * * @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(); }