laravel model（查询）

最新推荐文章于 2023-08-20 18:15:54 发布
最新推荐文章于 2023-08-20 18:15:54 发布
阅读量2.2k 收藏
点赞数
分类专栏： Laravel
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/x1207008324/article/details/101534050
版权 
namespace App\Models\Demand;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Support\Facades\DB;

class DemandModel extends Model {

	protected $table = 'demand';

	/**
	 * 依据条件获取项目
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionProject($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('project')
			->where(function($query) use($condition) {
				if (isset($condition['project_id']) && !empty($condition['project_id'])) {
					if (is_array($condition['project_id'])) {
						$query->whereIn('project_id', $condition['project_id']);
					} else {
						$query->where('project_id', '=', $condition['project_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['name']) && !empty($condition['name'])) {
					$query->where('project_name', '=', $condition['name']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['creater']) && !empty($condition['creater'])) {
				$query->where('project_creater', '=', $condition['creater']);
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取模块
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionModel($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('project_model')
			->where(function($query) use($condition) {
				if (isset($condition['pm_id']) && !empty($condition['pm_id'])) {
					if (is_array($condition['pm_id'])) {
						$query->whereIn('pm_id', $condition['pm_id']);
					} else {
						$query->where('pm_id', '=', $condition['pm_id']);
					}
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['project_id']) && !empty($condition['project_id'])) {
				if (is_array($condition['project_id'])) {
					$query->whereIn('project_id', $condition['project_id']);
				} else {
					$query->where('project_id', '=', $condition['project_id']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 根据条件获取需求
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionDemand($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		DB::connection()->enableQueryLog();
		$query = self::query();

		if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
			if (is_array($condition['demand_id'])) {
				$query->whereIn('demand_id', $condition['demand_id']);
			} else {
				$query->where('demand_id', '=', $condition['demand_id']);
			}
		}
		if (isset($condition['demand_name']) && !empty($condition['demand_name'])) {
			$query->where('demand_name', 'like', '%' . $condition['demand_name'] . '%');
		}
		if (isset($condition['name']) && !empty($condition['name'])) {
			$query->where('demand_name', 'like', '%' . $condition['name']);
		}
		if (isset($condition['model']) && !empty($condition['model'])) {
			if (is_array($condition['model'])) {
				$query->whereIn('pm_id', $condition['model']);
			} else {
				$query->where('pm_id', '=', $condition['model']);
			}
		}
		if (isset($condition['project_id']) && !empty($condition['project_id'])) {
			if (is_array($condition['project_id'])) {
				$query->whereIn('project_id', $condition['project_id']);
			} else {
				$query->where('project_id', '=', $condition['project_id']);
			}
		}
		if (isset($condition['demand_level']) && $condition['demand_level'] !== '') {
			$query->where('demand_level', '=', $condition['demand_level']);
		}
		if (isset($condition['demand_type']) && $condition['demand_type'] !== '') {
			$query->where('demand_type', '=', $condition['demand_type']);
		}
		if (isset($condition['status'])) {
			if (is_array($condition['status']) && !empty($condition['status'])) {
				$query->whereIn('demand_status', $condition['status']);
			} else if ($condition['status'] !== '') {
				$query->where('demand_status', '=', $condition['status']);
			}
		}
		if (isset($condition['status_not'])) {
			if (is_array($condition['status_not']) && !empty($condition['status_not'])) {
				$query->whereNotIn('demand_status', $condition['status_not']);
			} else if ($condition['status_not'] !== '') {
				$query->where('demand_status', '!=', $condition['status_not']);
			}
		}
		if (isset($condition['status_less_than']) && $condition['status_less_than'] !== '') {
			$query->where('demand_status', '<=', $condition['status_less_than']);
		}
		if (isset($condition['demand_from']) && $condition['demand_from'] !== '') {
			$query->where('demand_from', '=', $condition['demand_from']);
		}
		if (isset($condition['demand_from_user']) && !empty($condition['demand_from_user'])) {
			$query->where('demand_from_user', '=', $condition['demand_from_user']);
		}
		if (isset($condition['demand_next_user']) && !empty($condition['demand_next_user'])) {
			$query->where(function($query) use($condition) {
				$query->where('demand_next_user', 'like', '%[' . $condition['demand_next_user'] . ']%')->orWhere('demand_next_user', $condition['demand_next_user']);
			});
		}
		if (isset($condition['create']) && !empty($condition['create'])) {
			$query->where('demand_creater', '=', $condition['create']);
		}
		if (isset($condition['demand_create_date_start']) && !empty($condition['demand_create_date_start'])) {
			$query->where('demand_create_date', '>=', $condition['demand_create_date_start']);
		}
		if (isset($condition['demand_create_date_end']) && !empty($condition['demand_create_date_end'])) {
			$query->where('demand_create_date', '<=', $condition['demand_create_date_end']);
		}
		if (isset($condition['demand_last_modified_start']) && !empty($condition['demand_last_modified_start'])) {
			$query->where('demand_last_modified', '>=', $condition['demand_last_modified_start']);
		}
		if (isset($condition['demand_last_modified_end']) && !empty($condition['demand_last_modified_end'])) {
			$query->where('demand_last_modified', '<=', $condition['demand_last_modified_end']);
		}
		if (isset($condition['demand_dev_lead']) && !empty($condition['demand_dev_lead'])) {
			if (is_array($condition['demand_dev_lead'])) {
				$query->whereIn('demand_dev_lead', $condition['demand_dev_lead']);
			} else {
				$query->where('demand_dev_lead', '=', $condition['demand_dev_lead']);
			}
		}
		if (isset($condition['related_to_me']) && !empty($condition['related_to_me'])) {
			$query->where(function($query) use($condition) {
				$query->orWhere('demand_from_user', '=', $condition['related_to_me'])->orWhere('demand_next_user', 'like', '%[' . $condition['related_to_me'] . ']%')->orWhere('demand_next_user', $condition['related_to_me'])->orWhere('demand_creater', '=', $condition['related_to_me']);
			});
		}
		if (isset($condition['demand_functional_satisfaction']) && $condition['demand_functional_satisfaction'] !== '') {
			$query->where('demand_functional_satisfaction', '=', $condition['demand_functional_satisfaction']);
		}
		if (isset($condition['demand_side_test_time_start']) && $condition['demand_side_test_time_start'] !== '') {
			$query->where('demand_side_test_time', '>=', $condition['demand_side_test_time_start']);
		}
		if (isset($condition['demand_side_test_time_end']) && $condition['demand_side_test_time_end'] !== '') {
			$query->where('demand_side_test_time', '<=', $condition['demand_side_test_time_end']);
		}
		if (isset($condition['demand_side_adopt_time_start']) && $condition['demand_side_adopt_time_start'] !== '') {
			$query->where('demand_side_adopt_time', '>=', $condition['demand_side_adopt_time_start']);
		}
		if (isset($condition['demand_side_adopt_time_end']) && $condition['demand_side_adopt_time_end'] !== '') {
			$query->where('demand_side_adopt_time', '<=', $condition['demand_side_adopt_time_end']);
		}
		if (isset($condition['demand_uptime_start']) && !empty($condition['demand_uptime_start'])) {
			$query->where('demand_uptime', '>=', $condition['demand_uptime_start']);
		}
		if (isset($condition['demand_uptime_end']) && !empty($condition['demand_uptime_end'])) {
			$query->where('demand_uptime', '<=', $condition['demand_uptime_end']);
		}
		if (isset($condition['is_score']) && $condition['is_score'] !== '') {
			$query->where('demand_functional_satisfaction', '=', $condition['is_score'])->where('demand_communication_satisfaction', '=', $condition['is_score']);
		}

		switch ($type) {
			case 'count(*)':
				$sql = $query->count();
				break;
			case 'countBySum':
				$type = 'count(*) as all_demand,
					sum(demand_status = 1) as draft,
					sum(demand_status = 2) as waiting_time,
					sum(demand_status = 14) as to_be_decomposed,
					sum(demand_status = 3) as to_be_developed,
					sum(demand_status = 4) as in_development,
					sum(demand_status = 5) as to_be_tested,
					sum(demand_status = 6) as in_testing,
					sum(demand_status = 7) as suspend,
					sum(demand_status = 8) as test_completed,
					sum(demand_status = 9) as demander_acceptance,
					sum(demand_status = 10) as demand_side_approval,
					sum(demand_status = 11) as discard,
					sum(demand_status = 12) as stop,
					sum(demand_status = 13) as on_line_notification';
				$sql = $query->get(DB::raw($type))->toArray();
				break;
			case 'sum':
				$type = 'sum(demand_status != 11) as demand_total,
					sum(demand_status <= 9) as demand_in_progress';
				$sql = $query->get(DB::raw($type))->toArray();
				break;
			default:
				if (!empty($groupBy)) {
					$query->groupBy($groupBy);
				}

				if (!empty($orderBy)) {
					$query->orderBy($orderBy[0], $orderBy[1]);
				}

				if ($pageSize > 0 && $page > 0) {
					$start = ($page - 1) * $pageSize;
					$query->offset($start)->limit($pageSize);
				}
				$sql = $query->get($type)->toArray();
				break;
		}
//		print_r(DB::getQueryLog());
//		die();
		return $sql;
	}

	/**
	 * 依据条件获取版本详情
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionVersionDetail($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('demand_version_detail')
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand_id', $condition['demand_id']);
					} else {
						$query->where('demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['pv_id']) && !empty($condition['pv_id'])) {
				if (is_array($condition['pv_id'])) {
					$query->whereIn('pv_id', $condition['pv_id']);
				} else {
					$query->where('pv_id', '=', $condition['pv_id']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		 die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取版本
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionVersion($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('project_version')
			->where(function($query) use($condition) {
				if (isset($condition['pv_id']) && !empty($condition['pv_id'])) {
					if (is_array($condition['pv_id'])) {
						$query->whereIn('pv_id', $condition['pv_id']);
					} else {
						$query->where('pv_id', '=', $condition['pv_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['project_id']) && !empty($condition['project_id'])) {
					if (is_array($condition['project_id'])) {
						$query->whereIn('project_id', $condition['project_id']);
					} else {
						$query->where('project_id', '=', $condition['project_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['pv_code']) && !empty($condition['pv_code'])) {
					$query->where('pv_code', '=', $condition['pv_code']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status'])) {
					if (is_array($condition['status']) && !empty($condition['status'])) {
						$query->whereIn('pv_status', $condition['status']);
					} else if ($condition['status'] !== '') {
						$query->where('pv_status', '=', $condition['status']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_not'])) {
					if (is_array($condition['status_not']) && !empty($condition['status_not'])) {
						$query->whereNotIn('pv_status', $condition['status_not']);
					} else if ($condition['status_not'] !== '') {
						$query->where('pv_status', '!=', $condition['status_not']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['plan_release_start_date']) && !empty($condition['plan_release_start_date'])) {
					$query->where('pv_plan_date', '>=', $condition['plan_release_start_date']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['plan_release_end_date']) && !empty($condition['plan_release_end_date'])) {
					$query->where('pv_plan_date', '<=', $condition['plan_release_end_date']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_start_time']) && !empty($condition['create_start_time'])) {
					$query->where('pv_create_date', '>=', $condition['create_start_time']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_end_time']) && !empty($condition['create_end_time'])) {
					$query->where('pv_create_date', '<=', $condition['create_end_time']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['actual_release_start_date']) && !empty($condition['actual_release_start_date'])) {
					$query->where('pv_last_modified', '>=', $condition['actual_release_start_date']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['actual_release_end_date']) && !empty($condition['actual_release_end_date'])) {
				$query->where('pv_last_modified', '<=', $condition['actual_release_end_date']);
			}
		});

		switch ($type) {
			case 'count(*)':
				$sql = $select->count();
				break;
			case 'countBysum':
				$type = 'count(*) as total,
					sum(pv_status = 2) as published_version';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			default:
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				if (!empty($orderBy)) {
					$select->orderBy($orderBy[0], $orderBy[1]);
				}

				if ($pageSize > 0 && $page > 0) {
					$start = ($page - 1) * $pageSize;
					$select->offset($start)->limit($pageSize);
				}
				$sql = $select->get($type)->toArray();
				break;
		}
//		 die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取任务
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionTask($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('task')
			->where(function($query) use($condition) {
				if (isset($condition['task_id']) && !empty($condition['task_id'])) {
					if (is_array($condition['task_id'])) {
						$query->whereIn('task_id', $condition['task_id']);
					} else {
						$query->where('task_id', '=', $condition['task_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_name']) && !empty($condition['task_name'])) {
					$query->where('task_name', 'like', '%' . $condition['task_name'] . '%');
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand_id', $condition['demand_id']);
					} else {
						$query->where('demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['project_id']) && !empty($condition['project_id'])) {
					if (is_array($condition['project_id'])) {
						$query->whereIn('project_id', $condition['project_id']);
					} else {
						$query->where('project_id', '=', $condition['project_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['model']) && !empty($condition['model'])) {
					if (is_array($condition['model'])) {
						$query->whereIn('pm_id', $condition['model']);
					} else {
						$query->where('pm_id', '=', $condition['model']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_level']) && $condition['task_level'] !== '') {
					$query->where('task_level', '=', $condition['task_level']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status'])) {
					if (is_array($condition['status']) && !empty($condition['status'])) {
						$query->whereIn('task_status', $condition['status']);
					} else if ($condition['status'] !== '') {
						$query->where('task_status', '=', $condition['status']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_not'])) {
					if (is_array($condition['status_not']) && !empty($condition['status_not'])) {
						$query->whereNotIn('task_status', $condition['status_not']);
					} else if ($condition['status_not'] !== '') {
						$query->where('task_status', '!=', $condition['status_not']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_less_than']) && $condition['status_less_than'] !== '') {
					$query->where('task_status', '<=', $condition['status_less_than']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_date_start']) && !empty($condition['create_date_start'])) {
					$query->where('task_create_date', '>=', $condition['create_date_start']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_date_end']) && !empty($condition['create_date_end'])) {
					$query->where('task_create_date', '<=', $condition['create_date_end']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_next_user']) && !empty($condition['task_next_user'])) {
					$query->where('task_next_user', '=', $condition['task_next_user']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['is_inform']) && $condition['is_inform'] !== '') {
				$query->where('is_inform', '=', $condition['is_inform']);
			}
		});

		switch ($type) {
			case 'count(*)':
				$sql = $select->count();
				break;
			case 'sum':
				$type = 'sum(task_status <= 6) as total_task,
					sum(task_status <= 5) as under_way';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			case 'group_concat(task_coding_user,task_test_user)':
				$type = 'group_concat(task_coding_user) as task_coding_user,
				group_concat(task_test_user) as task_test_user';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			default:
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				if (!empty($orderBy)) {
					$select->orderBy($orderBy[0], $orderBy[1]);
				}

				if ($pageSize > 0 && $page > 0) {
					$start = ($page - 1) * $pageSize;
					$select->offset($start)->limit($pageSize);
				}
				$sql = $select->get($type)->toArray();
				break;
		}
//		 die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取缺陷
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionDefect($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('task_bug')
			->where(function($query) use($condition) {
				if (isset($condition['project_id']) && !empty($condition['project_id'])) {
					if (is_array($condition['project_id'])) {
						$query->whereIn('project_id', $condition['project_id']);
					} else {
						$query->where('project_id', '=', $condition['project_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['model']) && !empty($condition['model'])) {
					if (is_array($condition['model'])) {
						$query->whereIn('pm_id', $condition['model']);
					} else {
						$query->where('pm_id', '=', $condition['model']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand_id', $condition['demand_id']);
					} else {
						$query->where('demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_id']) && !empty($condition['task_id'])) {
					if (is_array($condition['task_id'])) {
						$query->whereIn('task_id', $condition['task_id']);
					} else {
						$query->where('task_id', '=', $condition['task_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['pv_id']) && !empty($condition['pv_id'])) {
					if (is_array($condition['pv_id'])) {
						$query->whereIn('pv_id', $condition['pv_id']);
					} else {
						$query->where('pv_id', '=', $condition['pv_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status'])) {
					if (is_array($condition['status']) && !empty($condition['status'])) {
						$query->whereIn('tb_status', $condition['status']);
					} else if ($condition['status'] !== '') {
						$query->where('tb_status', '=', $condition['status']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_not'])) {
					if (is_array($condition['status_not']) && !empty($condition['status_not'])) {
						$query->whereNotIn('tb_status', $condition['status_not']);
					} else if ($condition['status_not'] !== '') {
						$query->where('tb_status', '!=', $condition['status_not']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_less_than']) && $condition['status_less_than'] !== '') {
					$query->where('tb_status', '<=', $condition['status_less_than']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['tb_name']) && !empty($condition['tb_name'])) {
					$query->where('tb_name', 'like', '%' . $condition['tb_name'], '%');
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_emergency_level']) && $condition['task_emergency_level'] !== '') {
					$query->where('task_emergency_level', '=', $condition['task_emergency_level']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_date_start']) && !empty($condition['create_date_start'])) {
					$query->where('tb_create_date', '>=', $condition['create_date_start']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create_date_end']) && !empty($condition['create_date_end'])) {
					$query->where('tb_create_date', '<=', $condition['create_date_end']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['tb_next_user']) && !empty($condition['tb_next_user'])) {
				$query->where('tb_next_user', '=', $condition['tb_next_user']);
			}
		});

		switch ($type) {
			case 'count(*)':
				$sql = $select->count();
				break;
			case 'sum':
				$type = 'sum(tb_status <= 5) as total_defect,
					sum(tb_status <= 3) as to_be_solved';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			default:
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				if (!empty($orderBy)) {
					$select->orderBy($orderBy[0], $orderBy[1]);
				}

				if ($pageSize > 0 && $page > 0) {
					$start = ($page - 1) * $pageSize;
					$select->offset($start)->limit($pageSize);
				}
				$sql = $select->get($type)->toArray();
				break;
		}
		// die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取日志
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionLog($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('demand_log')
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand_id', $condition['demand_id']);
					} else {
						$query->where('demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['type'])) {
					if (is_array($condition['type']) && !empty($condition['type'])) {
						$query->whereNotIn('dl_type', $condition['type']);
					} else if ($condition['type'] !== '') {
						$query->where('dl_type', '!=', $condition['type']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['dl_type'])) {
					if (is_array($condition['dl_type']) && !empty($condition['dl_type'])) {
						$query->whereIn('dl_type', $condition['dl_type']);
					} else if ($condition['dl_type'] !== '') {
						$query->where('dl_type', '=', $condition['dl_type']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_id'])) {
					if (is_array($condition['task_id']) && !empty($condition['task_id'])) {
						$query->whereIn('task_id', $condition['task_id']);
					} else if ($condition['task_id'] !== '') {
						$query->where('task_id', '=', $condition['task_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['remark']) && !empty($condition['remark'])) {
					$query->where('dl_remark', 'like', '%' . $condition['remark'] . '%');
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['task_id_not'])) {
				if (is_array($condition['task_id_not']) && !empty($condition['task_id_not'])) {
					$query->whereNotIn('task_id', $condition['task_id_not']);
				} else {
					$query->where('task_id', '!=', $condition['task_id_not']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取项目权限
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionProjectAuthority($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('project_user')
			->where(function($query) use($condition) {
			if (isset($condition['user_id']) && !empty($condition['user_id'])) {
				if (is_array($condition['user_id'])) {
					$query->whereIn('user_id', $condition['user_id']);
				} else {
					$query->where('user_id', '=', $condition['user_id']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取配置
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionConfig($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('config')
			->where(function($query) use($condition) {
				if (isset($condition['config_id']) && !empty($condition['config_id'])) {
					if (is_array($condition['config_id'])) {
						$query->whereIn('config_id', $condition['config_id']);
					} else {
						$query->where('config_id', '=', $condition['config_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['project_id']) && !empty($condition['project_id'])) {
					if (is_array($condition['project_id'])) {
						$query->whereIn('project_id', $condition['project_id']);
					} else {
						$query->where('project_id', '=', $condition['project_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['attribute']) && !empty($condition['attribute'])) {
					if (is_array($condition['attribute'])) {
						$query->whereIn('config_attribute', $condition['attribute']);
					} else {
						$query->where('config_attribute', '=', $condition['attribute']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['like_attribute']) && !empty($condition['like_attribute'])) {
					$query->where('config_attribute', 'like', '%' . $condition['like_attribute']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['user_id']) && !empty($condition['user_id'])) {
				if (is_array($condition['user_id'])) {
					$query->whereIn('config_creater', $condition['user_id']);
				} else {
					$query->where('config_creater', '=', $condition['user_id']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取需求版本详情左关联版本
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionDemandVersionDetailLeftJoinVersion($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('demand_version_detail')
			->leftjoin('project_version', 'demand_version_detail.pv_id', '=', 'project_version.pv_id')
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand_id', $condition['demand_id']);
					} else {
						$query->where('demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['pv_id']) && !empty($condition['pv_id'])) {
				if (is_array($condition['pv_id'])) {
					$query->whereIn('pv_id', $condition['pv_id']);
				} else {
					$query->where('pv_id', '=', $condition['pv_id']);
				}
			}
		});

		if ($type == 'count(*)') {
			$sql = $select->count();
		} else {
			if (!empty($groupBy)) {
				$select->groupBy($groupBy);
			}

			if (!empty($orderBy)) {
				$select->orderBy($orderBy[0], $orderBy[1]);
			}

			if ($pageSize > 0 && $page > 0) {
				$start = ($page - 1) * $pageSize;
				$select->offset($start)->limit($pageSize);
			}
			$sql = $select->get($type)->toArray();
		}
//		die($select->select()->tosql());
		return $sql;
	}

	/**
	 * 依据条件获取需求左关联任务
	 * @param  Array            $condition 条件
	 * @param  String || Array  $type      结果集
	 * @param  String           $groupBy   聚合
	 * @param  Array            $orderBy   排序
	 * @param  Integer          $page      页
	 * @param  Integer          $pageSize  页数
	 * @return Integer || Array
	 */
	public static function getByConditionDemandLeftJoinTask($condition = array(), $type = '*', $groupBy = '', $orderBy = array(), $page = 0, $pageSize = 0) {
		$select = DB::table('demand')
			->leftjoin('task', 'demand.demand_id', '=', 'task.demand_id')
			->where(function($query) use($condition) {
				if (isset($condition['demand_id']) && !empty($condition['demand_id'])) {
					if (is_array($condition['demand_id'])) {
						$query->whereIn('demand.demand_id', $condition['demand_id']);
					} else {
						$query->where('demand.demand_id', '=', $condition['demand_id']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_name']) && !empty($condition['demand_name'])) {
					$query->where('demand_name', 'like', '%' . $condition['demand_name'] . '%');
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_from_user']) && !empty($condition['demand_from_user'])) {
					$query->where('demand_from_user', '=', $condition['demand_from_user']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['is_score']) && $condition['is_score'] !== '') {
					$query->where('demand_functional_satisfaction', '=', $condition['is_score'])->where('demand_communication_satisfaction', '=', $condition['is_score']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_push_mail_frequency']) && $condition['demand_push_mail_frequency'] !== '') {
					$query->where('demand_push_mail_frequency', '=', $condition['demand_push_mail_frequency']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status'])) {
					if (is_array($condition['status']) && !empty($condition['status'])) {
						$query->whereNotIn('demand_status', $condition['status']);
					} else if ($condition['status'] !== '') {
						$query->where('demand_status', '=', $condition['status']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['status_not'])) {
					if (is_array($condition['status_not']) && !empty($condition['status_not'])) {
						$query->whereNotIn('demand_status', $condition['status_not']);
					} else if ($condition['status_not'] !== '') {
						$query->where('demand_status', '!=', $condition['status_not']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_dev_lead']) && !empty($condition['demand_dev_lead'])) {
					if (is_array($condition['demand_dev_lead'])) {
						$query->whereIn('demand_dev_lead', $condition['demand_dev_lead']);
					} else {
						$query->where('demand_dev_lead', '=', $condition['demand_dev_lead']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['type_not']) && !empty($condition['type_not'])) {
					if (is_array($condition['type_not'])) {
						$query->whereNotIn('demand_type', $condition['type_not']);
					} else {
						$query->where('demand_type', '!=', $condition['type_not']);
					}
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['is_inform']) && $condition['is_inform'] !== '') {
					$query->where('is_inform', '=', $condition['is_inform']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_type']) && $condition['demand_type'] !== '') {
					$query->where('demand_type', '=', $condition['demand_type']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_coding_user']) && $condition['task_coding_user'] !== '') {
					$query->where('task.task_coding_user', '=', $condition['task_coding_user']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['task_test_user']) && $condition['task_test_user'] !== '') {
					$query->where('task.task_test_user', '=', $condition['task_test_user']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['create']) && $condition['create'] !== '') {
					$query->where('demand_creater', '=', $condition['create']);
				}
			})
			->where(function($query) use($condition) {
				if (isset($condition['demand_uptime_start']) && !empty($condition['demand_uptime_start'])) {
					$query->where('demand_uptime', '>=', $condition['demand_uptime_start']);
				}
			})
			->where(function($query) use($condition) {
			if (isset($condition['demand_uptime_end']) && !empty($condition['demand_uptime_end'])) {
				$query->where('demand_uptime', '<=', $condition['demand_uptime_end']);
			}
		});

		switch ($type) {
			case 'count(*)';
				$sql = $select->count();
				break;
			case 'group_concat(demand_id)';
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				$type = 'group_concat(demand.demand_id) as demand_id,
					demand_from_user';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			case 'group_concat(task_coding_user,task_test_user)';
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				$type = 'demand.demand_id,
					demand_name,
					demand_from_user,
					demand_creater,
					GROUP_CONCAT(task_coding_user) as task_coding_user,
					GROUP_CONCAT(task_test_user) as task_test_user';
				$sql = $select->get(DB::raw($type))->toArray();
				break;
			default:
				if (!empty($groupBy)) {
					$select->groupBy($groupBy);
				}

				if (!empty($orderBy)) {
					$select->orderBy($orderBy[0], $orderBy[1]);
				}

				if ($pageSize > 0 && $page > 0) {
					$start = ($page - 1) * $pageSize;
					$select->offset($start)->limit($pageSize);
				}
				$sql = $select->get($type)->toArray();
				break;
		}
		//die($select->select()->tosql());
		return $sql;
	}

}
缤纷落叶之忠
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
laravel Model 执行事务的实现
10-16
今天小编就为大家分享一篇laravel Model 执行事务的实现，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧
laravel model 两表联查示例
10-16
今天小编就为大家分享一篇laravel model 两表联查示例，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧
Laravel model 模型用法和部分问题解方法
青及笄经验分享
10-25 4563
Laravel model 模型用法和部分问题解方法，Laravel 初体验
在 Laravel 中，将模型的查询方法 self::where 与控制器结合使用是一种常见的操作方式。这样可以将业务逻辑更好地分离
Xerale的博客
08-14 269
这种方式使得控制器更加简洁，将查询逻辑封装在模型中，提高了代码的复用性和可读性。同时，它也符合 MVC（模型-视图-控制器）的设计模式。的查询方法，该方法接收一个名称参数，并通过。方法中，我们获取传入的名称并调用。在数据库中进行查询。模型中定义了一个名为。方法来获取查询结果。
Laravel 框架构造器的排序分组.子查询 & JOIN 查询 & 构造器的增删改 ⑦
最新发布
m0_61490399的博客
08-20 854
Laravel是一种流行的开源PHP Web应用程序框架，由Taylor Otwell在2011年创建并发布。它提供了一个简洁优雅的语法和丰富的功能集，旨在使Web开发过程更快速、简单和愉悦。MVC架构模式：Laravel采用了MVC（Model-View-Controller）架构模，将应用程序的逻辑分为不同的层，提高了代码的可维护性和可测试性。简洁的语法和表达力：Laravel框架支持具有简洁而表达力的语法，使得编写清晰、易读、易维护的代码成为可能。
laravel 子查询
jianchenn的博客
08-04 635
laravel子查询
Laravel 中使用子查询
wgchen
08-02 3885
Laravel 中使用子查询
laravel框架之模型（model）
error311的博客
07-24 1797
1. Eloquent ORM(对象关系模型) laravel 自带的，提供了一个美观的、简单的连接数据库数据库ActiveRecord实现，每张数据表都对应一个与该表交互的“Model模型”，模型允许在表中进行查询，插入，更新和删除操作 2.AR：ActiveRecord(活动记录)： 是一种领域模型模式，特点是一个模型类对应关系型数据库汇总的一个表，而模型类的一个实例对应表中的一行记录 3、AR模式三个核心（映射） （1）每个【数据表】：与数据表进行交互的Model【模...
Laravel Model 的增删改查
m0_58027884的博客
04-19 1782
Model类的增删改查： 查： use App\Http\Controllers\Controller; use App\Models\Home\Member; class Controllers extends Controller { //查询记录 public function select(){ // 查询所有记录只有name字段 $data = Member::all(['name']); // 打印查询信息 du
Laravel Model多表链接 联合查询 When查询
FuJinlong94的博客
05-03 990
laravel文档中model部分少得可怜 只能一点一点找资料慢慢摸索前行；laravel查询数据库方式很多也很灵活， 个人爱好还是喜欢使用model看着比较整洁。
如何利用预加载优化Laravel Model查询详解
10-19
主要给大家介绍了关于如何利用预加载优化Laravel Model查询的相关资料，文章通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面跟着小编来一起学习学习吧。
laravel model模型处理之修改查询或修改字段时的类型格式案例
10-16
今天小编就为大家分享一篇laravel model模型处理之修改查询或修改字段时的类型格式案例，具有很好的参考价值，希望对大家有所帮助。一起跟随想过来看看吧
LARAVEL框架Arr函数
wendyNo的博客
12-23 1103
<?php namespace Illuminate\Support; use ArrayAccess; use Illuminate\Support\Traits\Macroable; use InvalidArgumentException; class Arr { use Macroable; /** * Determine whether the given value is array accessible. *验证这个给定的值是否是数组或者继承A
laravel model基本使用方法
qq_16618179的博客
03-16 7334
model 基本方法 “` $orders = App\Models\TestModel::all(); foreach (ordersasordersasorders as order) { $order-&gt;users-&gt;get();} 如果一个订单有25个用户，将导致有26条SQL语句，使用with可解决这个问题 Book::with(‘user’)-&gt;...
聊一聊laravel query builder 使用子查询
热门推荐
心有猛虎，细嗅蔷薇！
11-22 1万+
概述：项目当中经常用到复杂SQL带有子查询，而Laravel的查询构造器并没有直接提供转化成子查询的方法，或者说尽管提供了方法，可是给出来的例子却不太具体，对刚上手的新手来说非常不友好，本文章主要是聊一聊Laravel如何构造各种带有子查询的SQL。 准备：首先，Laravel一般实现子查询的两种方式：1、toSql()+getQuery()+raw()方法： toSql()方法的作用是为了获取不带
Laravel - Eloquent 模型查询
三百两
03-09 700
模型文件 <?php namespace App; use Illuminate\Database\Eloquent\Model; class Student extends Model { protected $table = 'student'; protected $primaryKey = 'id'; } 控制器文件 public function ormQuery() { # 1.1 查询所有 // .
Laravel 模型关联建立与查询
青及笄经验分享
11-10 3200
hasone hasmany,belongsTo,belongsTomany,with,whereHas等关系，以及with，whereHas的使用
laravel模型获取表名_通过 Laravel Eloquent 模型实现简单增删改查操作
weixin_35985796的博客
01-19 3262
概述Eloquent 是一个 ActiveRecord ORM 框架，ORM 全称是 Object Relational Mapping，意为对象关系映射，用于实现面向对象编程语言里不同类型系统的数据之间的转换，简单来说，它会构建类与数据表之间的映射关系，从而建立起一个可在编程语言里使用的「虚拟对象数据库」。「ActiveRecord」是 ORM 的一种实现模式，Eloquent 则是 ...
laravel model（创建、更新、删除）
Anonymous
09-27 4928
namespace App\Models\Common; use Illuminate\Database\Eloquent\Model; use Illuminate\Support\Facades\DB; class CommonModel extends Model { /** * 创建 * @param String $table 表名 * @param...
Laravel Model例子
05-05
好的，这里是一个简单的 Laravel Model 的例子： 假设我们有一个名为 `User` 的模型，我们可以在 `app/Models/User.php` 文件中定义它： ```php <?php namespace App\Models; use Illuminate\Database\Eloquent\Factories\HasFactory; use Illuminate\Database\Eloquent\Model; class User extends Model { use HasFactory; protected $table = 'users'; protected $fillable = [ 'name', 'email', 'password', ]; protected $hidden = [ 'password', 'remember_token', ]; public function posts() { return $this->hasMany(Post::class); } } ``` 在上面的代码中，我们使用 `use` 关键字导入了 `Illuminate\Database\Eloquent\Factories\HasFactory` 和 `Illuminate\Database\Eloquent\Model` 类，并在 `User` 类中继承了 `Model` 类。我们还使用了 `HasFactory` trait，它提供了一个 `factory()` 方法，可以用于生成模型的测试数据。 在 `$table` 属性中指定了与此模型关联的数据表的名称。在 `$fillable` 属性中定义了可以被批量赋值的字段。在 `$hidden` 属性中指定了应该被隐藏的字段。 最后，我们在 `User` 模型中定义了一个 `posts()` 方法，它返回一个 `hasMany` 关联，用于获取该用户的所有帖子。 这只是一个简单的例子，Laravel 模型具有很多功能，可以帮助你快速构建应用程序。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值