/** * Run the migrations. * * @return void */ public function up() { set_time_limit(0); Schema::table('crowd_fundings', function ($table) { $table->integer('e_id'); }); $list = CrowdFunding::get(); foreach ($list as $key => $funding) { // handle event $event = new EventItem(); $event->e_title = $funding->c_title; $imgs = Img::toArray($funding->c_imgs); if (empty($imgs['cover_img'])) { $cover = ''; } else { $cover = $imgs['cover_img']; unset($imgs['cover_img']); } $event->cover_img = $cover; $event->e_brief = $funding->c_brief; $event->e_range = 0; $event->e_start_at = $funding->active_at; $event->e_end_at = $funding->end_at; $event->created_at = $funding->created_at; $event->e_status = 1; $event->save(); // handle ranges $range = new EventRange(); $range->e_id = $event->e_id; $range->s_id = $funding->s_id; $range->c_id = $funding->c_id; $range->p_id = $funding->pv_id; $range->save(); // handle imgs $funding->c_imgs = implode(',', $imgs); $funding->e_id = $event->e_id; $funding->save(); } }
public function putCrowdFunding($id) { $token = Input::get('token', ''); $u_id = Input::get('u_id', 0); $title = Input::get('title', ''); $cate = Input::get('cate', 1); $amount = Input::get('amount', 0); $time = Input::get('time', 0); $yield_time = Input::get('yield_time', 0); $shipping = Input::get('shipping', 0); $shipping_fee = Input::get('shipping_fee', 0); $brief = Input::get('brief', ''); $yield_desc = Input::get('yield_desc', ''); $content = Input::get('content', ''); $open_file = Input::get('open_file', 0); $local_only = Input::get('local_only', 0); $is_schedule = Input::get('is_schedule', 0); $active_at = Input::get('active_at'); if (empty($active_at)) { $active_at = Tools::getNow(); } $mobile = Input::get('mobile', ''); $price = Input::get('price', 0); $quantity = Input::get('quantity', 0); $is_limit = Input::get('is_limit', 0); $img_token = Input::get('img_token', ''); $img_token_2 = Input::get('img_token_2', ''); $apartment_no = Input::get('apartment_no', ''); $content = urldecode($content); $modified_img = Input::get('modified_img', ''); $modified_img_index = Input::get('modified_img_index', ''); if ($modified_img) { $modified_img = explode(',', $modified_img); } try { $user = User::chkUserByToken($token, $u_id); if ($cate == 8 && $user->u_type != 2) { throw new Exception("错误的发布类型", 2001); } $crowd_funding = CrowdFunding::find($id); if (empty($crowd_funding) || $crowd_funding->u_id != $u_id) { throw new Exception("无法获取到请求的众筹", 2001); } $funding_product = CrowdFundingProduct::where('cf_id', '=', $crowd_funding->cf_id)->first(); if (empty($funding_product)) { throw new Exception("库存信息丢失", 2001); } if (Cart::getCartTypeCount(Cart::$TYPE_CROWD_FUNDING, $funding_product->p_id)) { throw new Exception("已有人购买", 2001); } if ($apartment_no) { $tmp_base = TmpUserProfileBase::find($user->u_id); $tmp_base->u_apartment_no = $apartment_no; $tmp_base->save(); } $event = EventItem::find($crowd_funding->e_id); // put funding $event->e_title = $title; $event->e_brief = $brief; $event->e_start_at = $active_at; $date_obj = new DateTime($active_at); $date_obj->modify('+' . $time . ' days'); $event->e_end_at = $date_obj->format('Y-m-d H:i:s'); $crowd_funding->c_local_only = $local_only; $crowd_funding->c_yield_desc = $yield_desc; $crowd_funding->c_content = $content; $crowd_funding->c_yield_time = $yield_time; $crowd_funding->u_mobile = $mobile; $crowd_funding->c_is_schedule = $is_schedule; $crowd_funding->c_time = $time; $crowd_funding->c_shipping = $shipping; $crowd_funding->c_shipping_fee = $shipping_fee; $crowd_funding->c_target_amount = $amount; $crowd_funding->c_cate = $cate; $crowd_funding->c_open_file = $open_file; if ($amount <= 2000) { $crowd_funding->c_status = 4; } else { $crowd_funding->c_status = 1; } // if the user is an official user, set funding type to offical if ($user->u_type == 2) { $crowd_funding->c_cate = 8; } if (is_numeric($modified_img_index)) { $imgObj = new Img('crowd_funding', $img_token_2); $new_paths = []; if (!empty($modified_img)) { foreach ($modified_img as $old_path) { $new_path = $imgObj->reindexImg($id, $modified_img_index, $old_path); $new_paths[] = $new_path; $modified_img_index++; } $new_paths = Img::attachHost($new_paths); $crowd_funding->c_imgs = implode(',', $new_paths); } } if ($img_token_2) { $imgObj = new Img('crowd_funding', $img_token_2); $imgs = $imgObj->getSavedImg($crowd_funding->cf_id, $crowd_funding->c_imgs, true); if (!empty($modified_img)) { foreach ($modified_img as $del) { if (array_key_exists($del, $imgs)) { unset($imgs[$del]); } } } $crowd_funding->c_imgs = implode(',', $imgs); } if ($img_token) { $img_obj = new Img('event', $img_token); $cover_img = $img_obj->replace($event->e_id, 'cover_img'); $event->cover_img = $cover_img; } $crowd_funding->save(); $event->save(); // put funding product $funding_product = CrowdFundingProduct::where('cf_id', '=', $crowd_funding->cf_id)->first(); if (empty($funding_product)) { throw new Exception("库存信息丢失", 2001); } $funding_product->p_price = $price; $funding_product->p_target_quantity = $quantity; if ($is_limit) { $funding_product->p_max_quantity = $quantity; } else { $funding_product->p_max_quantity = 0; } $funding_product->save(); $re = Tools::reTrue('编辑众筹成功'); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '编辑众筹失败:' . $e->getMessage()); } return Response::json($re); }
public function postAd() { $title = Input::get('title', ''); $url = Input::get('url', ''); $brief = Input::get('brief', ''); $range = Input::get('range', ''); $cities = Input::get('cities', ''); $schools = Input::get('schools', ''); $positions = Input::get('positions', ''); $start_at = Input::get('start_at', ''); $end_at = Input::get('end_at', ''); $img_token = Input::get('img_token', ''); try { $ad_event = new EventItem(); $ad_event->e_title = $title; $ad_event->e_brief = $brief; $ad_event->url = $url; $ad_event->e_range = $range; $ad_event->e_start_at = $start_at; $ad_event->e_end_at = $end_at; $ad_event->addEvent(); $e_id = $ad_event->e_id; if ($range == 1) { $event_range = new EventRange(['c_id' => 0, 'p_id' => 0, 's_id' => 0]); $ad_event->ranges()->save($event_range); } if ($cities && $range == 2) { $city_sets = explode(',', $cities); foreach ($city_sets as $set) { $array = explode('|', $set); $event_range = new EventRange(['c_id' => $array[0], 'p_id' => $array[1]]); $ad_event->ranges()->save($event_range); } } if ($schools && $range == 3) { $schools = explode(',', $schools); foreach ($schools as $school) { $event_range = new EventRange(['s_id' => $school]); $ad_event->ranges()->save($event_range); } } if ($positions) { $positions = explode(',', $positions); foreach ($positions as $key => $position) { $event_position = new EventPosition(['position' => $position]); $ad_event->positions()->save($event_position); } } if ($img_token) { $imgObj = new Img('event', $img_token); $ad_event->cover_img = $imgObj->getSavedImg($e_id); $ad_event->save(); } $ad = new Advertisement(); $ad->e_id = $e_id; $ad->o_id = Tools::getOfficialOrgnizationId(); $ad->addAd(); $re = Tools::reTrue('添加广告成功'); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '添加广告失败:' . $e->getMessage()); } return Response::json($re); }
<?php $page->createTitle(); print $page->getHeader(); if (isset($_GET['msg'])) { $alert = new Alert(); $alert->printAlerts(); } include_once $_SERVER['DOCUMENT_ROOT'] . "/lib/modules/event.php"; $event = new EventItem($mySQL); $event->setID($_GET['e']); $event->createData(); if ($event->data) { $event->createEvent(); print $event->getEvent(); } else { print ' <div class="row pane">' . PHP_EOL; print ' <div class="col-xs-12">' . PHP_EOL; print ' <h2>No event selected to preview!</h2>' . PHP_EOL; print ' </div>' . PHP_EOL; print '</div>' . PHP_EOL; } ?> <div class="row pane"> <div class="col-xs-12"> <form class="form-horizontal" action="<?php print $_SERVER['REQUEST_URI']; ?> " method="get"> <div class="form-group"> <div class="col-xs-4 text-right">
public function cloneCrowdFunding() { $this->load(['eventItem', 'product']); $event = new EventItem(); $event->o_id = $this->eventItem->o_id; $event->e_title = $this->eventItem->e_title; $event->cover_img = $this->eventItem->cover_img; $event->e_brief = $this->eventItem->e_brief; $event->url = $this->eventItem->url; $event->e_range = $this->eventItem->e_range; $event->e_start_at = $this->eventItem->e_start_at; $event->e_end_at = $this->eventItem->e_end_at; $event->created_at = $this->eventItem->created_at; $event->e_status = $this->eventItem->e_status; $event->save(); $funding = new CrowdFunding(); $funding->u_id = $this->u_id; $funding->b_id = $this->b_id; $funding->c_status = $this->c_status; $funding->c_yield_desc = $this->c_yield_desc; $funding->c_content = $this->c_content; $funding->c_imgs = $this->c_imgs; $funding->c_yield_time = $this->c_yield_time; $funding->c_time = $this->c_time; $funding->c_shipping = $this->c_shipping; $funding->c_shipping_fee = $this->c_shipping_fee; $funding->c_target_amount = $this->c_target_amount; $funding->c_cate = $this->c_cate; $funding->created_at = $this->created_at; $funding->c_open_file = $this->c_open_file; $funding->c_praise_count = $this->c_praise_count; $funding->c_remark = $this->c_remark; $funding->c_amount = $this->c_amount; $funding->u_mobile = $this->u_mobile; $funding->c_local_only = $this->c_local_only; $funding->e_id = $event->e_id; $funding->save(); $product = new CrowdFundingProduct(); $product->cf_id = $funding->cf_id; $product->u_id = $this->product->u_id; $product->b_id = $this->product->b_id; $product->p_imgs = $this->product->p_imgs; $product->p_title = $this->product->p_title; $product->p_desc = $this->product->p_desc; $product->p_price = $this->product->p_price; $product->p_status = $this->product->p_status; $product->p_max_quantity = $this->product->p_max_quantity; $product->p_target_quantity = $this->product->p_target_quantity; $product->p_sort = $this->product->p_sort; $product->created_at = $this->product->created_at; $product->p_sold_quantity = $this->product->p_sold_quantity; $product->p_cart_quantity = $this->product->p_cart_quantity; $product->save(); return $event; }
public function postFunding() { $u_id = Tools::getOfficialUserId(); $b_id = Tools::getOfficialBoothId(); $title = Input::get('title', ''); $amount = Input::get('amount', 0); $time = Input::get('time', 0); $yield_time = Input::get('yield_time', 0); $shipping = Input::get('shipping', 0); $shipping_fee = Input::get('shipping_fee', 0); $brief = Input::get('brief', ''); $yield_desc = Input::get('yield_desc', ''); $content = Input::get('content', ''); $open_file = Input::get('open_file', 0); $active_at = Input::get('active_at'); $local_only = Input::get('local_only', 0); $range = Input::get('range', 1); $cities = Input::get('cities', 0); $schools = Input::get('schools', 0); if (empty($active_at)) { $active_at = Tools::getNow(); } $mobile = Input::get('mobile', ''); $price = Input::get('price', 0); $quantity = Input::get('quantity', 0); $is_limit = Input::get('is_limit', 0); $img_token = Input::get('img_token', ''); $content = urldecode($content); DB::beginTransaction(); try { $user = User::find($u_id); $user->load('profileBase', 'school'); $booth = Booth::find($b_id); // add event $event = new EventItem(); $event->e_title = $title; $event->e_brief = $brief; $event->e_range = $range; $event->e_start_at = $active_at; $date_obj = new DateTime($active_at); $date_obj->modify('+' . $time . ' days'); $event->e_end_at = $date_obj->format('Y-m-d H:i:s'); $event->addEvent(); $e_id = $event->e_id; // add funding $crowd_funding = new CrowdFunding(); $crowd_funding->u_id = $u_id; $crowd_funding->b_id = $booth->b_id; $crowd_funding->c_yield_desc = $yield_desc; $crowd_funding->c_content = $content; $crowd_funding->c_yield_time = $yield_time; $crowd_funding->u_mobile = $mobile; $crowd_funding->c_time = $time; $crowd_funding->c_shipping = $shipping; $crowd_funding->c_shipping_fee = $shipping_fee; $crowd_funding->c_target_amount = $amount; $crowd_funding->c_amount = 0.0; $crowd_funding->c_local_only = $local_only; $crowd_funding->c_praise_count = 0; $crowd_funding->c_remark = ''; $crowd_funding->c_open_file = $open_file; $crowd_funding->c_status = 4; $crowd_funding->c_cate = 8; $crowd_funding->e_id = $e_id; $crowd_funding->addCrowdFunding(); if ($img_token) { $imgObj = new Img('crowd_funding', $img_token); $crowd_funding->c_imgs = $imgObj->getSavedImg($crowd_funding->cf_id); $crowd_funding->save(); $imgObj = new Img('event', $img_token); $event->cover_img = $imgObj->getSavedImg($event->e_id); $event->save(); } // add funding product $funding_product = new CrowdFundingProduct(); $funding_product->cf_id = $crowd_funding->cf_id; $funding_product->u_id = $u_id; $funding_product->b_id = $booth->b_id; $funding_product->p_title = $title; $funding_product->p_desc = ''; $funding_product->p_price = $price; $funding_product->p_target_quantity = $quantity; $funding_product->p_sort = 0; if ($is_limit) { $funding_product->p_max_quantity = $quantity; } else { $funding_product->p_max_quantity = 0; } $funding_product->addProduct(); if ($range == 1) { $event_range = new EventRange(['c_id' => 0, 'p_id' => 0, 's_id' => 0]); $event->ranges()->save($event_range); } if ($cities && $range == 2) { $city_sets = explode(',', $cities); foreach ($city_sets as $key => $set) { $array = explode('|', $set); $event_range = new EventRange(['c_id' => $array[0], 'p_id' => $array[1]]); if ($key) { $new_event = $crowd_funding->cloneCrowdFunding(); } else { $new_event = $event; } $new_event->ranges()->save($event_range); } } if ($schools && $range == 3) { $schools = explode(',', $schools); foreach ($schools as $key => $school) { $event_range = new EventRange(['s_id' => $school]); if ($key) { $new_event = $crowd_funding->cloneCrowdFunding(); } else { $new_event = $event; } $new_event->ranges()->save($event_range); } } $re = Tools::reTrue('添加众筹成功'); DB::commit(); } catch (Exception $e) { $re = Tools::reFalse($e->getCode(), '添加众筹失败:' . $e->getMessage()); DB::rollback(); } return Response::json($re); }