Guest User

Untitled

a guest
Oct 22nd, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. public function clear_doubles(){
  2. $query = $this->db->query("SELECT * FROM `oc_product` WHERE xml_id IN ( SELECT xml_id FROM `oc_product` GROUP BY `xml_id` HAVING COUNT( `xml_id` ) > 1 ) ORDER BY `oc_product`.`xml_id` ASC");
  3.  
  4. $doubles = $query->num_rows != 0 ? $query->rows : [];
  5.  
  6. $original = array_shift($doubles);
  7.  
  8. foreach($doubles as $double){
  9. var_dump($original['xml_id'], $double['xml_id']); echo "<br>";
  10.  
  11. $this->load->model('catalog/product');
  12.  
  13. if($original['xml_id'] == $double['xml_id']){
  14. echo "delete ".$double['product_id']." double of ".$original['product_id']."<br>";
  15. $this->model_catalog_product->deleteProduct($double['product_id']);
  16. }else{
  17. $original['xml_id'] = $double['xml_id']; continue;
  18. }
  19. }
  20. }
Add Comment
Please, Sign In to add comment