Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.10 KB | None | 0 0
  1.     //get all accessories for new accessory check
  2.     public function showAllAccessories() {
  3.    
  4.         $db = Zend_Db_Table::getDefaultAdapter();
  5.         $select = new Zend_Db_Select($db);
  6.         $select->from('accessories_products')
  7.                ->order('accessories_products.accessories_id DESC');
  8.        
  9.         $result = $db->fetchAll($select);
  10.                        
  11.         return $result;
  12.     }
  13.    
  14.     public function newAccessoryCheck($array) {
  15.    
  16.     $todaysdate = new DateTime();
  17.     $todays_date = $todaysdate->format('Y-m-d H:i:s') . "\n";
  18.     $default_date = '0000-00-00 00:00:00';
  19.     $db = Zend_Db_Table::getDefaultAdapter();
  20.    
  21.             foreach($array as $all_accessories){
  22.                
  23.                 if ($all_accessories['accessories_last_modified'] != $default_date){
  24.                
  25.                     $expire_date = new DateTime($all_accessories['accessories_last_modified']);
  26.                     $expire_date->add(new DateInterval('P90D'));
  27.                     $expire_date = $date->format('Y-m-d H:i:s') . "\n";
  28.                    
  29.                     if ($todays_date > $expire_date) {
  30.                         $update_array = array('accessories_new' => 0);
  31.                         //echo $update_array;
  32.                         //$db->insert('accessories_products', $update_array);
  33.                     }
  34.                 }
  35.             }
  36.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement