public function changeStatus($order_id)
{
$row = Model_Orders::get($order_id);
if (!$row || $row['paid'] == 'true') {
return false;
//ERROR
}
$percent = Model_Percents::getPercentRow($row['owner_id']);
$percent = $percent['percent'];
$receiveMoney = floatval($row['price']) * floatval($percent) / 100;
$db = JO_Db::getDefaultAdapter();
$db->update('orders', array('paid' => 'true', 'paid_datetime' => new JO_Db_Expr('NOW()'), 'receive' => $receiveMoney), array('id = ?' => (int) $order_id));
$db->update(Model_Users::getPrefixDB() . 'users', array('earning' => new JO_Db_Expr('earning+' . $receiveMoney), 'total' => new JO_Db_Expr('total+' . $receiveMoney), 'sold' => new JO_Db_Expr('sold+' . $row['price']), 'sales' => new JO_Db_Expr('sales+1')), array('user_id = ?' => $row['owner_id']));
$you = Model_Users::getUser($row['user_id']);
#CHECK REFERAL
if ($you['referal_id'] != 0) {
$row['order_id'] = $order_id;
Model_Orders::referalMoney($row, $you);
}
$db->update(Model_Users::getPrefixDB() . 'users', array('buy' => new JO_Db_Expr('buy+1')), array('user_id = ?' => $row['user_id']));
$toinsert = array('sales' => new JO_Db_Expr('sales+1'), 'earning' => new JO_Db_Expr('earning+' . $row['price']));
#UPDATE ITEM
if ($row['extended'] == 'true') {
$db->update('users', array('items' => new JO_Db_Expr('items-1')), array('user_id = ?' => $row['user_id']));
$toinsert['status'] = 'extended_buy';
}
$db->update('items', $toinsert, array('id = ?' => $row['id']));
return true;
}
