SELECT (to_char(date_trunc('day',DOC.registrationdate),'dd.MM.yyyy')) AS dateOfDoc,
			 sum(case when DOC.doc_type_id=301 then DOC.sum 
    						when DOC.doc_type_id=303 then -DOC.sum else 0 end) AS cashReceiptsAll,
    	 sum(case when DOC.doc_type_id=301 AND DOCFIS.payment_method_id=1 then DOC.sum else 0 end) AS cash,
       sum(case when DOC.doc_type_id=301 AND DOCFIS.payment_method_id=2 then DOC.sum else 0 end) AS cashReceiptsCards,
       sum(case when DOC.doc_type_id=301 AND DOCFIS.payment_system_id=11 then DOC.sum else 0 end) AS cashReceiptsMalina,
       sum(case when DOC.doc_type_id=302 then DOC.sum else 0 end) AS cashReceiptsMobilePayments,
			(SELECT sum(accountingsum) FROM documents innerDOC1 
						WHERE innerDOC1.registrationdate IN (SELECT (SELECT max(registrationdate) 
											 																																																										FROM documents innerDOC2
																																																																						WHERE to_number(innerDOC2.description,'999999999') = CR.number
																																																																						AND innerDOC2.doc_type_id=401
                             											                          AND innerDOC2.registrationdate < date_trunc('day',DOC.registrationdate)
                                                         )
																																																										FROM cash_register AS CR JOIN remains_area RA ON CR.area_id = RA.remains_area_id
																																																										WHERE RA.placement_id=3310568)
      ) AS balanceStartDay
 
    FROM documents DOC JOIN documents_fiscals DOCFIS ON DOC.document_id = DOCFIS.doc_fiscal_id
 
    WHERE DOC.registrationDate >= date_trunc('day',date(('2012-01-01')))
					AND DOC.registrationDate<=to_timestamp(to_char(date(('2012.03.18')),'dd-mm-yyyy')||' 23:59:59','DD-MM-YYYY HH24:MI:SS')
 
GROUP BY date_trunc('day',DOC.registrationdate) 
ORDER BY date_trunc('day',DOC.registrationdate);