# 记账本后台

**Repository Path**: kennana/accounting_backstage

## Basic Information

- **Project Name**: 记账本后台
- **Description**: 记账本后台
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2019-01-03
- **Last Updated**: 2021-09-07

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

README.md
### 简易的命令行入门教程:
### Git 全局设置:
```
git config --global user.name "李金文"
git config --global user.email "xxxx"
```
### 创建 git 仓库:
```
mkdir accounting_backstage
cd accounting_backstage
git init
touch README.md
git add README.md
git commit -m "first commit"
git remote add origin https://gitee.com/kennana/accounting_backstage.git
git push -u origin master
```
### 已有仓库?
```
cd existing_git_repo
git remote add origin https://gitee.com/kennana/accounting_backstage.git
git push -u origin master
```

### login.php 登录界面的逻辑处理
```
<?php
header('Access-Control-Allow-Origin:*');
header('Content-type:application/json;charset=utf8');  
header('Access-Control-Allow-Methods:*');  
header('Access-Control-Allow-Headers:x-requested-with,content-type');
include 'Token.php';
include 'codeBack.config.php';
include 'connectMysql.php';
include 'empty.php';
$user_name = $_POST['user_name'];
$user_pass = $_POST["user_pass"];
if(!$user_name || !$user_pass){
	exit();
}
$user_pass = md5($user_pass);
$sql = "SELECT * FROM ac_user WHERE user_name='$user_name' AND user_pass='$user_pass'";
$result = $mysqli->query($sql);
$row = mysqli_fetch_object($result);

if($row->user_name == $user_name && $row->user_pass == $user_pass){
	// 查询成功
	$data = [
		"code"=>$CodeBack["LOGIN_SUCCESS_CODE"],
		"user_id"=>$row->user_id,
		"user_name"=>$row->user_name,
		"user_img"=>$row->user_img,
		"token"=>$row->token,
		"message"=>"登录成功",
	];
	echo json_encode($data);
}else {
	if($row->user_name != $user_name || $row->user_pass != $user_pass){
		$data = [
			"code"=>$CodeBack["LOGIN_FAILED_CODE"],
			"message"=>"账号或者密码不对",
		];
		echo json_encode($data);
	}else{
		$data = [
			"code"=>$CodeBack["LOGIN_FAILED_CODE"],
			"message"=>"账号密码不存在,请去注册"
		];
		echo json_encode($data);
	}
}
```

### register.php 注册页面的逻辑
```
<?php 
// 引入必要文件
include 'codeBack.config.php';
include 'Token.php';
include 'empty.php';
include 'connectMysql.php';

// 前要声明
$username = $_POST['user_name'];
$password = $_POST['user_pass'];
$userimg = "http://lorempixel.com/84/84/nature/";
$token = $token->product_token();
if(!$username || !$password || !$token || !$userimg){
	exit();
}
// 用户注册
// 先查询是否被注册过了
$sql = "SELECT * FROM ac_user WHERE user_name='$username'";
$result = $mysqli->query($sql);
$row = mysqli_fetch_object($result);
if(!$row->user_name){
	// 表示没有数据
	// 将数据插入数据库中
	$password = md5($password);
	$sql = "INSERT INTO  ac_user (user_name, user_pass, user_img, token) VALUES ('$username', '$password', '$userimg', '$token')";
	$result = $mysqli->query($sql);
	// 获取插入id
	$insert_id = $mysqli->insert_id;
	if($result){
		// 注册成功
		$data = [
			"code" => $CodeBack["REGISTER_SUCCESS_CODE"],
			"user_name" => $username,
			"message" => "注册成功"
		];
	}else {
		// 插入不成功，就是注册失败
		$data = [
			"code" => $CodeBack["REGISTER_FAILED_CODE"],
			"message"  => "注册失败",
		];
	}
	echo json_encode($data);
}else {
	if($row->user_name == $username){
		// 说明被人注册过了
		// 注册失败
		$data = [
			"code" => $CodeBack["REGISTER_FAILED_CODE"],
			"message"  => "昵称已被注册过，请换一个",
		];
		echo json_encode($data);
	}
}

// 安全判断
// 1 账号没被注册过，注册成功
// 2 账号被注册过，注册失败
```

### showInfo.php 简略信息显示页面
```
<?php
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";
$user_id = $_POST['user_id'];
$token = $_POST['token'];
$page = $_POST["page"];
$count = $_POST["count"];
if(!$user_id || !$token || !$page || !$count){
	exit();
}
$start = ($page-1) * $count;
$ac_user_sql = "SELECT * FROM ac_user WHERE user_id='$user_id' AND token='$token'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);

if($ac_user_row->user_id == $user_id && $ac_user_row->token == $token){
	$ac_user_info_sql = "SELECT * from ac_user_info WHERE user_id='$user_id'  order by id desc LIMIT $start,$count";
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	while ($ac_user_info_row=mysqli_fetch_object($ac_user_info_result)) {
		$array[] = $ac_user_info_row;
	}
	if(count($array)>0){
		// 说明有数据
		$data = [
			"code"=>$CodeBack["SHOWINFO_SUCCESS_CODE"],
			"user_id"=>$user_id,
			"user_img"=>$ac_user_row->user_img,
			"data"=>$array,
			"message"=>"查询成功",
		];
		echo json_encode($data);
	}else {
		// 没有数据存在
		$data = [
			"code"=>$CodeBack["SHOWINFO_FAILED_CODE"],
			"user_id"=>$user_id,
			"user_img"=>$ac_user_row->user_img,
			"data"=>$array,
			"message"=>"暂无数据",
		];
		echo json_encode($data);
	}
}
```

### addInfo.php 记账页面逻辑处理
```
<?php  
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";
header("connection","keep-alive");
$date = $_POST["date"];
$morning = $_POST["morning"];
$afternoon = $_POST["afternoon"];
$evening = $_POST["evening"];
$other = $_POST["other"];
$userid = $_POST["user_id"];
$token = $_POST["token"];
if(!$date || !$morning || !$afternoon || !$evening || !$other || !$userid || !$token){
	exit();
}
$ac_user_sql = "SELECT * from ac_user WHERE user_id='$userid' AND token='$token'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);
if($ac_user_row->token == $token && $ac_user_row->user_id == $userid){
	// 查找成功
	$ac_user_info_sql = "INSERT INTO ac_user_info (date,morning,afternoon,evening,other,user_id) VALUES('$date','$morning','$afternoon','$evening','$other','$userid')";
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	if($ac_user_info_result){
		// 插入成功
		$data = [
			"code"=>$CodeBack["ADDINFO_SUCCESS_CODE"],
			"user_id"=>$ac_user_row->user_id,
			"id"=>$mysqli->insert_id,
			"message"=>"添加成功",
		];
		echo json_encode($data);
	}else {
		$data = [
			"code"=>$CodeBack["ADDINFO_FAILED_CODE"],
			"message"=>"添加失败，请稍后再试",
		];
		echo json_encode($data);
	}
}
```

### editInfo.php 编辑页面逻辑处理
```
<?php  
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";
$user_id = $_POST['user_id'];
$token = $_POST['token'];
$user_name = $_POST["user_name"];
$id = $_POST["id"];
if(!$user_id || !$token || !$user_name ||!$id){
	exit();
}
$ac_user_sql = "SELECT * FROM ac_user WHERE user_id='$user_id' AND token='$token'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);
if($ac_user_row->token == $token && $ac_user_row->user_id == $user_id){
	// 查找成功
	$ac_user_info_sql = "SELECT * FROM ac_user_info WHERE user_id='$user_id' AND id='$id'";
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	$ac_user_info_row = mysqli_fetch_object($ac_user_info_result);
	if(count((array)$ac_user_info_row)){
		// 大于 0 表示插入成功
		// 插入成功
		$data = [
			"code"=>$CodeBack["EDITINFO_SUCCESS_CODE"],
			"user_id"=>$ac_user_row->user_id,
			"id"=>$id,
			"date"=>$ac_user_info_row->date,
			"morning"=>$ac_user_info_row->morning,
			"afternoon"=>$ac_user_info_row->afternoon,
			"evening"=>$ac_user_info_row->evening,
			"other"=>$ac_user_info_row->other,
		];
		echo json_encode($data);
	}else {
		$data = [
			"code"=>$CodeBack["EDITINFO_FAILED_CODE"],
			"message"=>"获取失败，请稍后再试",
		];
		echo json_encode($data);
	}
}
```

### editSubmit.php 编辑完成之后提交逻辑处理
```
<?php  
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";

$date = $_POST['date'];
$morning = $_POST['morning'];
$afternoon = $_POST["afternoon"];
$evening = $_POST["evening"];
$other = $_POST["other"];
$user_id = $_POST["user_id"];
$token = $_POST["token"];
$id = (int)$_POST["id"];
if(!$date || !$morning || !$afternoon || !$evening || !$other || !$user_id || !$id || !$token){
	exit();
}

$ac_user_sql = "SELECT * FROM ac_user WHERE user_id='{$user_id}' AND token='{$token}'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);
if($ac_user_row->token == $token && $ac_user_row->user_id == $user_id){
	// 查找成功
	$ac_user_info_sql = "UPDATE ac_user_info SET date='{$date}',morning='{$morning}',afternoon='{$afternoon}',evening='{$evening}',other='{$other}' WHERE id='{$id}' AND user_id='{$user_id}'" ;
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	if($ac_user_info_result){
		$data = [
			"code"=>$CodeBack["EDITSUBMIT_SUCCESS_CODE"],
			"user_id"=>$user_id,
			"id"=>$id,
			"message"=>"修改成功",
		];
		echo json_encode($data);
	}else {
		$data = [
			"code"=>$CodeBack["EDITSUBMIT_FAILED_CODE"],
			"user_id"=>$user_id,
			"id"=>$id,
			"message"=>"修改失败",
		];
		echo json_encode($data);
	}
	
}
```

### info.php 详细信息显示页面逻辑出路
```
<?php  
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";

$user_id = $_POST['user_id'];
$token = $_POST['token'];
$id = $_POST['id'];
$user_name = $_POST["user_name"];
$user_img = $_POST["user_img"];

if(!$user_name || !$token || !$id || !$user_name || !$user_img){
	exit();
}

$ac_user_sql = "SELECT * FROM ac_user WHERE user_id='$user_id' AND token='$token'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);
if($ac_user_row->token == $token && $ac_user_row->user_id == $user_id){
	// 查找成功
	$ac_user_info_sql = "SELECT date,morning,afternoon,evening,other FROM ac_user_info WHERE user_id='$user_id' AND id='$id'";
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	$ac_user_info_row = mysqli_fetch_object($ac_user_info_result);
	if(count(((array)$ac_user_info_row))){
		// 大于 0 表示插入成功
		// 插入成功
		$data = [
			"code"=>$CodeBack["INFO_SUCCESS_CODE"],
			"user_id"=>$ac_user_row->user_id,
			"id"=>$id,
			"data"=>$ac_user_info_row,
			"message"=>"查看详细信息成功",
		];
		echo json_encode($data);
	}else {
		$data = [
			"code"=>$CodeBack["INFO_FAILED_CODE"],
			"message"=>"查看详细信息失败",
		];
		echo json_encode($data);
	}
}
```

### Token.php 生成
```
<?php
class Token {
	// 设置一些静态变量
	private static $METHOD = "product_token" ;
	private static $SECRET = "123456ken" ;
	private static $NAMESPACE = "Account\Admin\Token" ;
	public function product_token() {
		$date = date("Y-m-d",time());
		$http_host = ($_SERVER['HTTP_HOST']);
		$api_token = md5($http_host . Token::$NAMESPACE . $date . Token::$METHOD . Token::$SECRET);
		return $api_token;
	}
}

$token = new Token();
```

### diary.php 日记逻辑处理
```
<?php  
include 'codeBack.config.php';
include "connectMysql.php";
include "empty.php";

$user_id = $_POST["user_id"];
$user_name = $_POST["user_name"];
$diary = $_POST["diary"];
$token = $_POST["token"];
if(!$user_id || !$user_name || !$diary || !$token){
	exit();
}

$ac_user_sql = "SELECT * FROM ac_user WHERE user_id='$user_id' AND token='$token'";
$ac_user_result = $mysqli->query($ac_user_sql);
$ac_user_row = mysqli_fetch_object($ac_user_result);
if($ac_user_row->token == $token && $ac_user_row->user_id == $user_id){
	// 查找成功
	$ac_user_info_sql = "INSERT INTO ac_user_diary (user_name,diary,user_id) VALUES('$user_name','$diary','$userid')";
	$ac_user_info_result = $mysqli->query($ac_user_info_sql);
	if($ac_user_info_result){
		// 大于 0 表示插入成功
		// 插入成功
		$data = [
			"code"=>$CodeBack["DIARY_SUCCESS_CODE"],
			"user_id"=>$user_id,
			"id"=>$mysqli->insert_id,
			"message"=>"保存成功",
		];
		echo json_encode($data);
	}else {
		$data = [
			"code"=>$CodeBack["DIARY_FAILED_CODE"],
			"message"=>"保存失败，请稍候重试",
		];
		echo json_encode($data);
	}
}
```

### data_config.php 数据库配置
```
<?php
$config = [
	// 服务器名称
	"servername" => "localhost",
	"username" => "root",
	"password" => "123456",
	"dbname" => "account"
];
```
### connectMysql.php 链接数据库
```
<?php 
include 'database_config.php';
$mysqli = new mysqli($config["servername"],$config["username"],$config["password"],$config["dbname"]);
if($mysqli->connect_error){
	die("连接失败" . $mysqli->connect_error);
}
$mysqli->query("set names utf8");
```

### codeBack.config.php 返回code的配置
```
<?php
// namespace Account\Admin\CodeBack;
// 这是一个用来返回 code 的数字码提示的
$CodeBack = [
    "LOGIN_SUCCESS_CODE"=>0,
    "LOGIN_FAILED_CODE"=>1001,
    "REGISTER_SUCCESS_CODE"=>0,
    "REGISTER_FAILED_CODE"=>1002,
    "UPLOADFILE_SUCCESS_CODE"=>0,
    "UPLOADFILE_FAILED_CODE"=>1003,
    "ADDINFO_SUCCESS_CODE"=>0,
    "ADDINFO_FAILED_CODE"=>1004,
    "SHOWINFO_SUCCESS_CODE"=>0,
    "SHOWINFO_FAILED_CODE"=>1005,
    "EDITINFO_SUCCESS_CODE"=>0,
    "EDITINFO_FAILED_CODE"=>1006,
    "EDITSUBMIT_SUCCESS_CODE"=>0,
    "EDITSUBMIT_FAILED_CODE"=>1007,
    "INFO_SUCCESS_CODE"=>0,
    "INFO_FAILED_CODE"=>1008,
    "DIARY_SUCCESS_CODE"=>0,
    "DIARY_FAILED_CODE"=>1009,
];
```

### empty.php 空函数处理
```
<?php  
// 实现简单的
if(empty($_POST)){
	exit();
	// 啥都不做
}
```