public function getDemands($idstr, $bids = "", $key = "")
{
$ids = explode(",", $idstr);
$conditions = " 1!=1";
foreach ($ids as $id) {
$id = trim($id);
if (empty($id)) {
continue;
}
$conditions .= " or sortpath like '%," . $id . ",%' ";
}
$catemodel = new Category();
$catarray = $catemodel->getbysql2array($conditions);
if (!$catarray) {
return;
}
$cateids = implode(",", $catarray);
//TODO:去掉注释
$condition = " 1=1 ";
$condition = " status=0 and is_pay=1 ";
// $condition.='and status != -1 and deposit!=0';
$condition .= " and category_id in ( {$cateids} )";
$condition .= " and expire_time>now()";
if (substr($bids, -1) == ',') {
$bids = substr($bids, 0, -1);
}
if (!empty($bids)) {
$condition .= " and bid in ( {$bids} ) ";
}
if (!empty($key)) {
$condition .= " and title like '%" . urldecode($key) . "%' ";
}
//echo "condition =$condition";exit();
return $this->whereRaw($condition)->orderby("id", "desc")->get()->toArray();
}
public function editDemand($id)
{
$demand = Demand::findOrFail($id);
$cattree = $this->InitClassSelectOption(0, $demand->category_id);
$cates = Category::where('parent_id', '=', 0)->orderby('id', 'desc')->get();
$user = User::whereRaw('id=' . $demand->user_id)->get()->first();
$brands = Brand::where("cateid", '=', $demand->category_id)->orderBy('id', 'desc')->get();
// var_dump($brands);exit();
$dc = new DemandController();
$bidinfo = $bidinfo = $dc->getbidinfo($demand);
$deli = delivery::whereRaw('deid=' . $demand->id)->get()->first();
$data = array('demand' => $demand, 'cates' => $cates, 'user' => $user, 'bids' => $bidinfo['bids'], 'bidinfo' => $bidinfo, 'deli' => $deli, 'catetree' => $cattree, 'brands' => $brands);
return view("admin.edemand")->with($data);
}
public function eidtCategory($cid, $pid, $slug, $sort)
{
$level = 0;
$sortpath = "0,";
if ($pid != 0) {
$pcate = Category::find($pid);
$level = $pcate->levels;
$sortpath = $pcate->sortpath;
}
//找出父类别
if ($level == 0) {
$cateid = 10;
}
if ($level == 1) {
$cateid = $pid * 100;
}
//第二级
if ($level == 2) {
$cateid = $pid * 1000;
}
//第三级
if ($level == 3) {
$cateid = $pid * 1000;
}
//第三级
//找出当前的编号
$findid = Category::where("levels", "=", $level + 1)->where("id", ">=", $cateid)->max("id");
//echo "the find id is:".$findid."<br />";
if ($findid) {
$cateid = $findid + 1;
}
//在当前的编号上加1
// echo "the cateid is:".$cateid."<br />";
$pinyin = CUtf8_PY::encode($slug);
$cate = new Category();
$cate->id = $cateid;
$cate->parent_id = $pid;
$cate->name = $pinyin;
$cate->slug = $slug;
$cate->sort = $sort;
$cate->levels = $level + 1;
$cate->sortpath = $sortpath . $cateid . ",";
$cate->save();
$oldcate = Category::find($cid);
$allcateneedmodify = Category::where("sortpath", 'like', $oldcate->sortpath)->select();
foreach ($allcateneedmodify as $key => $val) {
$newsortpath = str_replace($val->oldpath, $cate->sortpath, $val->sortpath);
$val::update(['sortpath' => $newsortpath]);
}
// $uinfos=array(
// "sortpath"=>"replace(sortpath,'".$oldcate->sortpath."','".$cate->sortpath
// ."')"
// );
// $cate::where("sortpath",'like',$oldcate->sortpath)->update($uinfos);
// DB::statement("update categories set sortpath=replace(sortpath,'".$oldcate->sortpath."','".$cate->sortpath
// ."') where sortpath like '".$oldcate->sortpath."'");
// $cate::statement("update categories set sortpath=");
// $cate::where("sortpath",'like','%,'.$cid.',%')->update($uinfos);
$cate::where("id", '=', $cid)->delete();
}
public function showDemand($id)
{
try {
$demand = Demand::findOrFail($id);
} catch (ModelNotFoundException $e) {
return Redirect::to('/')->withInput()->withErrors('竞购信息不存在或已被删除！');
}
$onecate = $demand->cat1;
$twocate = $demand->cat2;
$tricate = $demand->cat3;
$path = array();
if ($onecate != 0) {
$cinfo = Category::find($onecate);
if ($cinfo) {
$path[] = array('id' => $cinfo->id, 'name' => $cinfo->slug);
}
}
if ($twocate != 0) {
$cinfo = Category::find($twocate);
if ($cinfo) {
$path[] = array('id' => $cinfo->id, 'name' => $cinfo->slug);
}
}
if ($tricate != 0) {
$cinfo = Category::find($tricate);
if ($cinfo) {
$path[] = array('id' => $cinfo->id, 'name' => $cinfo->slug);
}
}
// print_r($demand);
$bids = $demand->bids;
$myBid = null;
$bidinfo = $this->getbidinfo($demand);
$lowprice = $bidinfo['lowprice'];
if (isset(Auth::user()->id)) {
foreach ($bids as $bid) {
if ($bid->user_id == Auth::user()->id) {
$myBid = $bid;
break;
}
}
}
$data = array('demand' => $demand, 'bids' => $bids, 'myBid' => $myBid, 'lowprice' => $lowprice, 'path' => $path);
if ($this->ismobile()) {
return view('demand.mobile.show', $data);
} else {
return view('demand.show', $data);
}
}
function ajax_brand()
{
header("Content-Type:text/html;charset=utf-8");
if (!isset($_GET['id']) || empty($_GET['id'])) {
echo $this->ecm_json_encode(false);
return;
}
$id = $_GET['id'];
$id = intval($id);
// var_dump($_GET);exit();
$catemodel = new Category();
$cate = $catemodel->getbrand($id);
// var_dump($cate);exit();
$data = array();
foreach ($cate as $key => $val) {
$onedata = array();
$onedata['cate_name'] = $val['slug'];
$onedata['cate_id'] = $val['id'];
$data[] = $onedata;
}
echo $this->ecm_json_encode(array_values($data));
return;
}
