Właśnie to namierzyłem :) 


2018-04-30 13:05 GMT+02:00 Rafał Z. <zajbox@gmail.com>:
tak. Dopisać w funkcji LockTables w invoiceedit tabele 'divisions'

2018-04-30 12:13 GMT+02:00 Marcin <marcin@nicram.net>:
Poprawka, to nie ten fragment.

Przy edycji faktury, jak zaznaczy się "Użyj bieżących danych klienta" do do tabeli documents lądują prawie same nulle

2018-04-30 11:52 GMT+02:00 Marcin <marcin@nicram.net>:
w lib/LMSManagers/LMSFinanceManager.php

to zapytanie nie zwraca kompletnych danych
    public function GetInvoiceContent($invoiceid)
    {
        global $PAYTYPES, $LMS;

        if ($result = $this->db->GetRow('SELECT d.id, d.type AS doctype, d.number, d.name, d.customerid,
				d.userid, d.address, d.zip, d.city, d.countryid, cn.name AS country,
				d.ten, d.ssn, d.cdate, d.sdate, d.paytime, d.paytype, d.numberplanid,
				d.closed, d.cancelled, d.published, d.reference, d.reason, d.divisionid,
				(SELECT name FROM vusers WHERE id = d.userid) AS user, n.template,
				d.div_name AS division_name, d.div_shortname AS division_shortname,
				d.div_address AS division_address, d.div_zip AS division_zip,
				d.div_city AS division_city, d.div_countryid AS division_countryid,
				d.div_ten AS division_ten, d.div_regon AS division_regon, d.div_account AS account,
				d.div_inv_header AS division_header, d.div_inv_footer AS division_footer,
				d.div_inv_author AS division_author, d.div_inv_cplace AS division_cplace,
				d.recipient_address_id, d.post_address_id,
				a.city as rec_city, a.zip as rec_zip, a.postoffice AS rec_postoffice,
				a.name as rec_name, a.address AS rec_address,
				c.pin AS customerpin, c.divisionid AS current_divisionid,
				c.street, c.building, c.apartment,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_street ELSE a2.street END) AS post_street,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_building ELSE a2.house END) AS post_building,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_apartment ELSE a2.flat END) AS post_apartment,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_name ELSE a2.name END) AS post_name,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_address ELSE a2.address END) AS post_address,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_zip ELSE a2.zip END) AS post_zip,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_city ELSE a2.city END) AS post_city,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_postoffice ELSE a2.postoffice END) AS post_postoffice,
				(CASE WHEN d.post_address_id IS NULL THEN c.post_countryid ELSE a2.country_id END) AS post_countryid,
				cp.name AS post_country
				FROM documents d
				JOIN customeraddressview c ON (c.id = d.customerid)
				LEFT JOIN countries cn ON (cn.id = d.countryid)
				LEFT JOIN numberplans n ON (d.numberplanid = n.id)
				LEFT JOIN vaddresses a ON d.recipient_address_id = a.id
				LEFT JOIN vaddresses a2 ON d.post_address_id = a2.id
				LEFT JOIN countries cp ON (d.post_address_id IS NOT NULL AND cp.id = a2.country_id) OR (d.post_address_id IS NULL AND cp.id = c.post_countryid)
				WHERE d.id = ? AND (d.type = ? OR d.type = ? OR d.type = ?)', array($invoiceid, DOC_INVOICE, DOC_CNOTE, DOC_INVOICE_PRO)))


W dniu 30 kwietnia 2018 11:35 użytkownik Marcin <marcin@nicram.net> napisał:
Potwierdzam

W dniu 25 kwietnia 2018 19:41 użytkownik V_Syphon <v_syphon@o2.pl> napisał:
Czy rozwiązałeś ten problem  ? Mam to samo.

Dnia 21 marca 2018 15:14 Rafal K <r99@wp.pl> napisał(a):

Witam,

Wydaje mi się ze był podobny problem,  fvat wystawia się dobrze , ale po próbie edycji fvat (zmiana np sposobu płatności)  z listy faktur wywala mi dane klienta ( załącznik) ,a w liscie faktur zamiast danych są dwa przecinki , ,

 

jak sobie poradzić z tym ?

 

Pozdrawiam

Rafał

 

 


_______________________________________________
lms mailing list

_______________________________________________
lms mailing list
lms@lists.lms.org.pl
http://lists.lms.org.pl/mailman/listinfo/lms




--
Pozdrawiam
Marcin / nicraM



--
Pozdrawiam
Marcin / nicraM



--
Pozdrawiam
Marcin / nicraM

_______________________________________________
lms mailing list
lms@lists.lms.org.pl
http://lists.lms.org.pl/mailman/listinfo/lms



_______________________________________________
lms mailing list
lms@lists.lms.org.pl
http://lists.lms.org.pl/mailman/listinfo/lms




--
Pozdrawiam
Marcin / nicraM