/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('areas', function (Blueprint $table) {
$table->increments('id');
$table->string('areaname', 50);
$table->integer('parent_id');
$table->string('short_name', 50);
$table->integer('zipcode');
$table->string('pinyin', 100);
$table->tinyInteger('level');
$table->tinyInteger('sort');
$table->timestamps();
});
// INSERT INTO Area VALUES (110000,'北京',0,'北京',NULL,NULL,1,1);
$area = new Area();
$area->id = 110000;
$area->areaname = '北京';
$area->parent_id = 0;
$area->short_name = '北京';
$area->level = 1;
$area->sort = 1;
$area->save();
}
public function address(Request $request, $id = 0)
{
header("Content-Type:text/html;charset=utf-8");
if ($id == 0) {
echo "参数错误,没有找到订单";
exit;
}
//这个地方,需要判断一下有没有tendree的权限
// echo "userid=".Auth::user()->id;
$order = Orders::where("id", "=", $id)->where("userid", "=", Auth::user()->id)->where("step", "=", 2)->first();
//只有支付到了第二段才有可能去选地址
if ($order == null) {
echo "参数错误,没有找到订单";
exit;
}
$uid = Auth::user()->id;
$useraddrs = Address::where("user_id", "=", $uid)->get();
$provices = Area::whereRaw('parent_id=1')->orderby('id', 'asc')->get();
$areas = Area::whereRaw('1=1')->orderBy('id', 'desc')->get();
$order = Orders::findOrFail($id);
$data = array('order' => $order, 'areas' => $areas, 'provices' => $provices, 'useraddrs' => $useraddrs);
return view('pay.address', $data);
}
public function area(Request $request)
{
$area = Area::select("id", "areaname")->where("parent_id", '=', $request->input('areaid'))->get();
return json_encode($area);
}
