Welcome Guest, Not a member yet? Register   Sign In
Help with datamapper database design and structure
#10

[eluser]Andy78[/eluser]
This:

Code:
$user->save(array('order' => $order, 'food' => $food->all);

Doesn't work it flags up the error cannot relate user to food.

This seems to work not sure it can be condensed

Code:
function create_order(){
        
        //Get user info
        $user_id = 74;
        $user = new User();
        $user->where('id', $user_id)->get();
        
        //Get takeaway info
        $takeaway_id = 13;
        $takeaway = new Takeaway();
        $takeaway->where('id', $takeaway_id)->get();
        
        // Add other order information
        $order = new Order();
        $order->payment_type_id = 2;
        $order->order_price = 3;
        $order->delivery_cost = 3;
        $order->total_price = $order->order_price + $order->delivery_cost;
        $order->delivery_type = 1;
        $order->order_paid = 1;
        //$order->delivery_time = now();
        $order->delivery_notes = 'text';
        $order->processed = 1;
        $order->strWebServiceResponse = 'test';
        
        //get foods for order on id
        $foods = array('94', '93');
        
        $food = new Food();
        $food->where_in('id', $foods)->get();
        
        
        $order->save($food->all);
        $order->save($takeaway);
        $order->save($user);
        
        
    }


Messages In This Thread
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:01 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:33 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:45 AM
Help with datamapper database design and structure - by El Forum - 04-11-2012, 08:58 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:22 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 07:54 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:38 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 10:51 AM
Help with datamapper database design and structure - by El Forum - 04-12-2012, 11:04 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 04:37 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 07:36 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 09:27 AM
Help with datamapper database design and structure - by El Forum - 04-13-2012, 10:34 AM
Help with datamapper database design and structure - by El Forum - 04-16-2012, 02:15 AM



Theme © iAndrew 2016 - Forum software by © MyBB