1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
| <?php
/** PHPExcel */
include 'Classes/PHPExcel.php';
include('config.php');
// Create new PHPExcel object
$objPHPExcel = new PHPExcel();
// Add some data
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A1', 'Date');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A3', 'Banque');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('B3', 'Compte');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('C3', 'Intitule');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('D3', 'Montant');
$sql="SELECT intituleCompte,noCompte,MontantT
FROM banque, t_societe, t_inventaire
WHERE banque.IdSoc= t_societe.IdSoc
ANd t_societe.IdSoc = t_inventaire.IdSoc";
$res=mysql_query($sql) or die ('Erreur affichage!');
while($data=mysql_fetch_row($res))
{
$intitule=$data[0];
$nocompte=$data[1];
$montant=$data[2];
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('A4', 'Banque SCOREDO');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('B4', $intitule);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('C4', $nocompte);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('D4', $montant);
}
///////////////////////////////////////////////////////////////////////
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F2', 'Details especes');
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F3',10000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F4',5000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F5',1000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F6',500);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F7',100);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F8',100);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F9',50);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F10',20);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F11',10);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F12',5);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F13',2);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F14',1);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('F15','TOTAL');
$sql="SELECT B10000,B5000,B1000,B500,P100,P100bis,P50,P20,P10,P5,P2,P1,MontantT
FROM t_inventaire";
$res=mysql_query($sql) or die ('Erreur affichage détail espèce!');
while($data=mysql_fetch_row($res))
{
$B10000=$data[0];
$B5000=$data[1];
$B1000=$data[2];
$B500=$data[3];
$P100=$data[4];
$P100bis=$data[5];
$P50=$data[6];
$P20=$data[7];
$P10=$data[8];
$P5=$data[9];
$P2=$data[10];
$P1=$data[11];
$MontantT=$data[12];
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G3',$B10000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G4',$B5000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G5',$B1000);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G6',$B500);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G7',$P100);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G8',$P100bis);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G9',$P50);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G10',$P20);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G11',$P10);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G12',$P5);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G13',$P2);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G14',$P1);
$objPHPExcel->setActiveSheetIndex(0)
->setCellValue('G15',$MontantT);
}
///////////////////////////////////////////////////////////////////////
//Redirect output to a client’s web browser (Excel5)
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="Depot.xls"');
header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
exit;
?> |
