/** * @return \yii\db\ActiveQuery */ public function getCustomerUserName() { return $this->hasOne(Customer::className(), ['customer_user_name' => 'customer_user_name']); }
/** * @return \yii\db\ActiveQuery */ public function getCustomerUserNames() { return $this->hasMany(Customer::className(), ['customer_user_name' => 'customer_user_name'])->viaTable('cart', ['item_id' => 'item_id']); }
public function actionShippingorder() { $delivery_name = $_POST['delivery_name']; $order_id = $_POST['order_id']; $idetails_id = $_POST['idetails_id']; $tracking_name = $_POST['tracking_name']; $model = OrderDetails::find()->where(['order_id' => $order_id, 'idetails_id' => $idetails_id])->one(); $model->delivery_name = $delivery_name; $model->order_status = 'shipped'; $model->tracking_number = $tracking_name; $model->save(); $designer = Designer::find()->where(['designer_id' => $model->designer_id])->one(); $order = Orders::find()->where(['order_id' => $model->order_id])->one(); $customer = Customer::find()->where(['customer_user_name' => $order->customer_user_name])->one(); /* Yii::$app->mail->compose() ->setFrom($designer->designer_email) ->setTo($customer->customer_email) ->setSubject('Regarding your Order in Nudostilo') ->send(); */ echo $delivery_name . '-' . $order_id . '-' . $idetails_id; }