public function run()
{
DB::table('auctions')->delete();
$collection = [];
foreach ($collection as $record) {
Auction::create($record);
}
}
/**
* Creates a new Product model.
* If creation is successful, the browser will be redirected to the 'view' page.
* @return mixed
*/
public function actionCreate()
{
$model = new Product();
$model->scenario = 'create';
if ($model->load(Yii::$app->request->post())) {
$image1 = UploadedFile::getInstance($model, 'image1');
if ($image1 != NULL) {
$name1 = date('Y_m_d_H_i_s_') . $image1->baseName . '.' . $image1->extension;
$model->image1 = $name1;
}
$image2 = UploadedFile::getInstance($model, 'image2');
if ($image2 != NULL) {
$name2 = date('Y_m_d_H_i_s_') . $image2->baseName . '.' . $image2->extension;
$model->image2 = $name2;
}
$image3 = UploadedFile::getInstance($model, 'image3');
if ($image3 != NULL) {
$name3 = date('Y_m_d_H_i_s_') . $image3->baseName . '.' . $image3->extension;
$model->image3 = $name3;
}
if ($model->save()) {
if ($model->auction == "YES") {
$auction = new Auction();
$auction->product_id = $model->id;
$auction->value = $model->price;
$auction->save();
}
if ($image1 != NULL) {
$image1->saveAs('img/products/' . $name1);
}
if ($image2 != NULL) {
$image2->saveAs('img/products/' . $name2);
}
if ($image3 != NULL) {
$image3->saveAs('img/products/' . $name3);
}
return $this->redirect(['view', 'id' => $model->id]);
} else {
return $this->render('create', ['model' => $model]);
}
} else {
return $this->render('create', ['model' => $model]);
}
}
public function actionWinner($id)
{
$auction = Auction::findOne($id);
if ($auction) {
$auction->status = 'INACTIVE';
if ($auction->save()) {
$return = $id . '-';
if (!$auction->user_id) {
$return .= '/';
} elseif ($auction->user_id == Yii::$app->user->id) {
$return .= '+';
} else {
$return .= $auction->user_id;
}
echo $return;
} else {
echo "no save " . $id;
}
} else {
echo "no auction " . $id;
}
}
public function getAuctions()
{
return $this->hasMany(Auction::className(), ['product_id' => 'id']);
}
public function actionRankList()
{
$user = Yii::$app->session->get('user');
if (empty($user)) {
echo json_encode(['status' => 0, 'message' => 'Wrong request'], JSON_PRETTY_PRINT);
exit;
}
$request = Yii::$app->request;
$auctionId = $request->post('auctionId');
if (empty($auctionId)) {
echo json_encode(['status' => 0, 'message' => 'Wrong params'], JSON_PRETTY_PRINT);
exit;
}
$auction = Auction::find()->select('week, seats')->where(['id' => $auctionId])->limit(1)->one();
$query = new Query();
$rankInfoAry = $query->select('bid.offer, bid.created, `user`.family_name')->from('bid')->leftJoin('`user`', '`bid`.`user_id` = `user`.`id`')->where(['auction_id' => $auctionId])->orderBy(['bid.offer' => SORT_DESC, 'bid.id' => SORT_ASC])->all();
$lang = Util::getLanguage();
$view = $lang == 'en' ? 'rankList' : 'rankList-cn';
Util::setLanguage($lang);
return $this->render($view, compact('auction', 'rankInfoAry'));
}
public function listOne($id)
{
//show single
$auction = Auction::with($this->related)->findOrFail($id);
return view('auctions.single', compact('auction'));
}
