当我向涉及不同控制器方法的不同数据库表添加多个条目时,如何使用MVC结构正确构建CakePHP 3中的代码?
一般来说,我对编码相当陌生,但我决心找出正确的方法来构建我的代码。
我正在用CakePHP 3建立一个网站,我有一个结帐页面,可以根据会员级别添加1或2个用户,以及处理付款。
checkout方法在my MembershipLevelsController中。该控制器用于不同级别成员的CRUD操作。用户导航到成员列表(索引方法),选择他们想要的级别,然后将他们发送到该级别的结帐(查看)页面。
因此,这个结帐视图可能有三种形式。1)。用户#1(向用户发布/添加方法)2)。用户#2(向用户发布/添加方法)3)。自定义条纹形式。(张贴到membershipLevels/收费方法)
charge方法将返回的stripe响应数据保存到membership_orders表中。
目前我正在使用ajax和发送用户数据。现在,add方法通常有自己的模板(视图)来添加用户,但我将其设置为添加1或2个用户,并在不同的视图中处理付款。
我不确定这是正确的方式来结构我的代码?用户控制器完成用户信息的所有处理(即任何CRUD操作)似乎是合乎逻辑的。或者,我是否应该在不同的控制器中进行所有的处理例如MembershipLevels控制器或MembershipOrders控制器?
一个参数是,当我将用户数据从membership_levels/checkout视图发送到users/add controller方法时,验证错误被发送到users/add视图。由于我目前使用ajax,我能够注入响应与验证错误意味着用户/添加视图到我的结帐视图,但我不确定这是正确的方式去做吗?
我也走进了死胡同。我还需要能够连接与正在创建的订单创建的第一个(或主)用户帐户(即保存新用户的id到我的membership_orders表中的user_id字段),但这似乎是不可能的,我越尝试。这就引出了我的第二个论点,即在不同的控制器方法中处理所有信息。
参数二:当添加第一个用户时,我需要一种方法来与我正在工作的控制器通信id号,但我不知道如何做到这一点。似乎我可以在用户信息保存后创建一个变量,其中包含id号,但只有在之后,因为id不知道,直到我保存它对吗?(因为它是自动递增的)
如果我处理订单控制器中的所有内容(因为订单表和用户表由user_id链接),CakePHP可能会自动添加user_id,但我希望我的代码是DRY的,并且不想重用代码在不同的控制器中添加用户。
MembershipLevels控制器:
private function stripeConfig() {
$stripe = [
"secret_key" => "sk_test",
"publishable_key" => "pk_test"
];
$set_key = 'Stripe'Stripe::setApiKey($stripe['secret_key']);
return [$stripe, $set_key];
}
public function charge() {
$this->stripeConfig();
$token = $this->request->data('stripeToken');
$amount = $this->request->data('billing_amount');
$customer = 'Stripe'Customer::create(array(
'email' => $this->request->data('email'),
'card' => $token
));
$charge = 'Stripe'Charge::create(array(
'customer' => $customer->id,
'amount' => $amount*100,
'currency' => 'usd'
));
$orderTable = TableRegistry::get('MembershipOrders');
$order = $orderTable->newEntity();
if ($this->request->is('post')) {
$order = $orderTable->patchEntity($order, $this->request->data);
$order->user_id = $this->request->data('user_id'); //Can't even save a hard coded number with a hidden input for this field.
$order->billing_name = $charge->card->name;
$order->billing_street = $charge->card->address_line1 . " " . $charge->card->address_line2;
$order->billing_city = $charge->card->address_city;
$order->billing_state = $charge->card->address_state;
$order->billing_zip = $charge->card->address_zip;
$order->billing_country = $charge->card->address_country;
$order->subtotal = $charge->amount/100;
$order->tax = 0;
$order->total = $charge->amount/100;
$order->payment_type = $charge->card->funding;
$order->card_type = $charge->card->brand;
$order->account_number = "XXXX XXXX XXXX ".$charge->card->last4;
$order->expiration_month = $charge->card->exp_month;
$order->expiration_year = $charge->card->exp_year;
$order->status = $charge->status;
$order->gateway = "Stripe";
if ($customer->livemode === true) {
$order->gateway_environment = 'live';
} else {
$order->gateway_environment = 'sandbox';
}
$order->subscription_transaction_id = $customer->id;
$order->payment_transaction_id = $charge->id;
$order->timestamp = date('Y-m-d H:i:s');
if ($orderTable->save($order)) {
$this->Flash->success(__('The order has been saved.'));
} else {
$this->Flash->error(__('The order could not be saved. Please, try again.'));
}
}
$this->set(compact('token', 'customer', 'charge'));
}
public function checkout($id = null) {
$keys = $this->stripeConfig();
$membershipLevel = $this->MembershipLevels->get($id, [
'contain' => []
]);
$userTable = TableRegistry::get('users');
$user = $userTable->newEntity();
$this->set(compact('keys', 'user', 'membershipLevel'));
$this->set('_serialize', ['membershipLevel', 'user']);
}
Users/Add Controller Method:
public function add()
{
$user = $this->Users->newEntity();
if ($this->request->is('post')) {
$user = $this->Users->patchEntity($user, $this->request->data);
if(!empty($this->request->data('role'))) {
$user->role = $this->request->data('role');
} else {
$user->role = 4;
}
if( $this->request->data('second_user_added') === '1' ) {
$user->second_user_added = $this->request->data('second_user_added');
} else {
$user->second_user_added = 0;
$user->code = $this->uniqueToken();
}
if( !empty($this->request->data('primary_user')) ) {
$user->group_id = $this->request->data('username');
} elseif ( !empty($this->request->data('secondary_user')) ) {
$user->group_id = $this->request->data('secondary_user');
}
if ($this->Users->save($user)) {
$user_id = $user->id;
$this->Flash->success(__('You have been added.'));
return $this->redirect(['controller' => 'pages', 'action' => 'home']);
} else {
$this->Flash->error(__('You could not be added. Please, try again.'));
}
}
$this->set(compact('user'));
$this->set('_serialize', ['user']);
}
MembershipOrdersTable:
public function initialize(array $config)
{
parent::initialize($config);
$this->table('membership_orders');
$this->displayField('id');
$this->primaryKey('id');
$this->belongsTo('Sessions', [
'foreignKey' => 'session_id',
'joinType' => 'INNER'
]);
$this->belongsTo('Users', [
'foreignKey' => 'user_id',
'joinType' => 'INNER'
]);
$this->belongsTo('Memberships', [
'foreignKey' => 'membership_id',
'joinType' => 'INNER'
]);
}
UsersTable:
public function initialize(array $config)
{
parent::initialize($config);
$this->table('users');
$this->displayField('id');
$this->primaryKey('id');
$this->addBehavior('Timestamp');
$this->hasMany('MembershipOrders', [
'foreignKey' => 'user_id'
]);
}
嗯,我不确定这是否是正确的方法,但是我想出了两种不同的方法来将用户Id添加到Orders表中。
1)。我在添加主用户时保存条带令牌,然后在保存订单数据时添加条带令牌匹配的用户Id。
即:
if ($order_id = $ordersTable->save($order)) {
$usersTable = TableRegistry::get('Users');
$query = $usersTable
->find('all')
->where(['affiliate_token' => $order_id->affiliate_token])
->first();
$order_id->user_id = $query->id;
$ordersTable->save($order_id);
$this->Flash->success(__('The order has been saved.'));
}
2)。我在添加主用户时登录,然后我可以在添加订单时获取登录的用户id并将其保存到订单中。
。应用程序控制器:
public function beforeRender(Event $event) {
$this->set('logged_in', $this->Auth->user('id'));
}
用户/添加方法:
if ($this->Users->save($user)) {
if( !empty($this->request->data('primary_user')) ) {
//Make sure no on is logged in already
if( isset($logged_in) ) {
$this->Auth->logout();
} else {
//Log user in using Auth if primary user
$this->Auth->setUser($user->toArray());
}
}
$this->Flash->success(__('You have been added.'));
}
MembershipLevels/充电方法:
if ($this->request->is('post')) {
$order = $ordersTable->patchEntity($order, $this->request->data);
if ( isset($logged_in) ) {
$order->user_id = $logged_in;
}
$order->membership_level_id = $this->request->data('membership_level_id');
etc...
}