+ function insLager($data) {
+ $rc = $this->db->Begin();
+ $sql = "SELECT nextval(('id'::text)::regclass) as id from id";
+ $rs = $this->db->getOne($sql);
+ $sql = "INSERT INTO inventory (warehouse_id,parts_id,shippingdate,employee_id,bin_id,qty,trans_id,trans_type_id,comment) ";
+ $sql .= "VALUES (:wid,:parts_id,now(),:employee_id,:bid,:onhand,:next,:tt,'Shopübernahme')";
+ $data['next'] = $rs['id'];
+ $data['tt'] = $this->transtype;
+ $data['bid'] = $this->lager;
+ $data['wid'] = $this->warehouse_id;
+ $data['employee_id'] = $this->employee_id;
+ $rc = $this->db->insert($sql,$data);
+ if ( $rc ) {
+ $this->db->Commit();
+ } else {
+ $this->db->Rollback();
+ }
+ }