Guest User

Untitled

a guest
Jul 19th, 2018
1,125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. tickets
  2. id
  3.  
  4. ticket_products
  5. ticket_id
  6. product_id
  7. id
  8.  
  9. trying:
  10.  
  11. $ticket = orm::factory('ticket', 1);
  12. $result = $ticket->product->where('product_id', '=', 2)->limit(2)->find_all();
  13.  
  14. $ticket->remove('product', $result[0]);
  15.  
  16. produces:
  17.  
  18. DELETE FROM `ticket_products` WHERE `ticket_id` = 1 AND `product_id` = 2
  19.  
  20. but I want:
  21.  
  22. DELETE FROM `ticket_products` WHERE `ticket_id` = 1 AND `product_id` = 2 AND `id` = 1
  23.  
  24. .
  25. .
  26. .
  27.  
  28. Model_Ticket
  29.  
  30. 3 class Model_Ticket extends ORM
  31. 4 {
  32. 5
  33. 6 // Relationships
  34. 7 protected $_has_many = array
  35. 8 (
  36. 9 'product' => array('model' => 'product', 'through' => 'ticket_products')
  37. 10 );
  38.  
  39. Model_Ticket_Product
  40.  
  41. 1 <?php defined('SYSPATH') OR die('No direct access allowed.');
  42. 2
  43. 3 class Model_Ticket_Product extends ORM
  44. 4 {
  45. 5 protected $_belongs_to = array('ticket' => array());
  46. 6 }
Add Comment
Please, Sign In to add comment