includes/bulk_updater.inc

   1 <?php
   2 require_once('includes/sql_set.inc');
   3
   4 class BulkUpdater extends OrderAction {
   5         protected $priority_date;
   6         protected $priority_time;
   7         protected $hold_until_date;
   8         protected $required_date;
   9         protected $expiry_date;
  10         protected $comment;
  11
  12         public function __construct(array $data) {
  13                 parent::__construct($data);
  14                 print_r($data);
  15
  16                 foreach(explode(' ', "priority_date priority_time hold_until_date required_date expiry_date comment") as $att) {
  17                         $this->$att = $data['bulk'][$att];
  18                 }
  19         }
  20
  21         public function update() {
  22                 foreach($this->detail_ids as $detail_id) {
  23                         $set = new SqlSet();
  24                         $set->addDatetime($this->priority_date, $this->priority_time, 'priority')
  25                                         ->addDate($this->hold_until_date, 'hold_until_date')
  26                                         ->addDate($this->required_date, 'required_date')
  27                                         ->add($this->comment, 'comment');
  28
  29                         db_query("UPDATE ".TB_PREF."sales_order_details
  30                                                         SET {$set->toString()}
  31                                                         WHERE id = $detail_id", "Problem update order details $detail_id");
  32                 }
  33         }
  34 }
  35 ?>