Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //get all accessories for new accessory check
- public function showAllAccessories() {
- $db = Zend_Db_Table::getDefaultAdapter();
- $select = new Zend_Db_Select($db);
- $select->from('accessories_products')
- ->order('accessories_products.accessories_id DESC');
- $result = $db->fetchAll($select);
- return $result;
- }
- public function newAccessoryCheck($array) {
- $todaysdate = new DateTime();
- $todays_date = $todaysdate->format('Y-m-d H:i:s') . "\n";
- $default_date = '0000-00-00 00:00:00';
- $db = Zend_Db_Table::getDefaultAdapter();
- foreach($array as $all_accessories){
- if ($all_accessories['accessories_last_modified'] != $default_date){
- $expire_date = new DateTime($all_accessories['accessories_last_modified']);
- $expire_date->add(new DateInterval('P90D'));
- $expire_date = $date->format('Y-m-d H:i:s') . "\n";
- if ($todays_date > $expire_date) {
- $update_array = array('accessories_new' => 0);
- //echo $update_array;
- //$db->insert('accessories_products', $update_array);
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement