Bin will be removed on June 1, 2014 in favor of http://gist.github.com. Please save all your pastes before then. So long, and thanks for all the fish!×
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
//    Get data from SQL Server
    protected function _importData() {
        //Set the invoice header and line items models
        if (!isset($this->InvoiceHeader)) {
            $this->loadModel('InvoiceHeader');
            if (!isset($this->InvoiceDetail)) {
                $this->loadModel('InvoiceDetail');
            }
        }
 
    //  Set data to local variable    
        $this->InvoiceHeader->Behaviors->attach('Containable');        
        $importData = $this->InvoiceHeader->find('all', array(
            'fields' => $this->InvoiceHeader->defaultFields,
            'contain' => array(
                'InvoiceDetail' => array('fields' => $this->InvoiceDetail->defaultFields))
                )
        );
    //  pr($importData);
        return $importData;
 
}