public function actionExportXls()
{
$model = new Contact('search');
$model->unsetAttributes();
if (isset($_GET['Contact'])) {
$model->attributes = $_GET['Contact'];
}
if (isset($_SESSION['criteria']) && $_SESSION['criteria'] != null && $_SESSION['criteria'] instanceof EMongoCriteria) {
$criteria = $_SESSION['criteria'];
} else {
$criteria = new EMongoCriteria();
}
$dataProvider = new EMongoDocumentDataProvider('Contact', array('criteria' => $criteria, 'pagination' => false));
$contacts = $dataProvider->data;
$data = array(1 => array_keys($model->attributeExportedLabels()));
setlocale(LC_ALL, 'fr_FR.UTF-8');
foreach ($contacts as $contact) {
$line = array();
foreach (array_keys($model->attributeExportedLabels()) as $attribute) {
if ($contact->{$attribute} != null && !empty($contact->{$attribute})) {
$line[] = iconv("UTF-8", "ASCII//TRANSLIT", $contact->{$attribute});
//solution la moins pire qui ne fait pas bugge les accents mais les convertit en caractere generique
} else {
$line[] = "-";
}
}
$data[] = $line;
}
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', true, 'Contact list');
$xls->addArray($data);
$xls->generateXML('Contact list');
}
/**
* Export des echantillons issus de la recherche en xls
*/
public function actionExportXls()
{
$model = new Echantillon('search');
$model->unsetAttributes();
if (isset($_GET['Echantillon'])) {
$model->attributes = $_GET['Echantillon'];
}
// reprend les critères de la dernière recherche
$dataprovider = new CActiveDataProvider('Echantillon', array('criteria' => $_SESSION['criteria'], 'pagination' => array('pageSize' => CommonTools::XLS_EXPORT_NB)));
// supprime la pagination pour exporter l'ensemble des echantillons
// $echantillons = $dataprovider->data;
$data = array(1 => array_keys($model->attributeExportedLabels()));
setlocale(LC_ALL, 'fr_FR.UTF-8');
$nb = 0;
foreach ($dataprovider->data as $ech) {
$line = array();
foreach (array_keys($model->attributeExportedLabels()) as $attribute) {
if ($attribute != 'notes') {
if ($ech->{$attribute} != null && !empty($ech->{$attribute})) {
$line[] = trim(iconv('UTF-8', 'ASCII//TRANSLIT', $ech->{$attribute}));
// solution la moins pire qui ne fait pas bugge les accents mais les convertit en caractere generique
} else {
$line[] = "-";
}
} else {
foreach ($ech->{$attribute} as $noteValue) {
$line[] = trim(iconv('UTF-8', 'ASCII//TRANSLIT', $noteValue->CLE . ' : ' . $noteValue->VALEUR));
}
}
}
$data[] = $line;
}
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', true, 'Sample list');
$xls->addArray($data);
$xls->generateXML('sample list');
}
/**
* export xls des biobanques
*/
public function actionExportXls()
{
$model = new Biobank('search');
$model->unsetAttributes();
if (isset($_GET['Biobank'])) {
$model->attributes = $_GET['Biobank'];
}
if (isset($_SESSION['criteria']) && $_SESSION['criteria'] != null && $_SESSION['criteria'] instanceof EMongoCriteria) {
$criteria = $_SESSION['criteria'];
} else {
$criteria = new EMongoCriteria();
}
$biobanks = Biobank::model()->findAll($criteria);
$data = array(1 => array_keys(Biobank::model()->attributeExportedLabels()));
setlocale(LC_ALL, 'fr_FR.UTF-8');
foreach ($biobanks as $biobank) {
$line = array();
foreach (array_keys($biobank->attributeExportedLabels()) as $attribute) {
if (isset($biobank->{$attribute}) && $biobank->{$attribute} != null && !empty($biobank->{$attribute})) {
$line[] = iconv("UTF-8", "ASCII//TRANSLIT", $biobank->{$attribute});
//solution la moins pire qui ne fait pas bugge les accents mais les convertit en caractere generique
} else {
$line[] = "-";
}
}
$line[] = iconv("UTF-8", "ASCII//TRANSLIT", $biobank->getShortContact());
$line[] = iconv("UTF-8", "ASCII//TRANSLIT", $biobank->getEmailContact());
$contact = $biobank->getContact();
if ($contact != null) {
$line[] = iconv("UTF-8", "ASCII//TRANSLIT", $contact->getFullAddress());
} else {
$line[] = "No address";
}
$data[] = $line;
}
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', true, 'Biobank list');
$xls->addArray($data);
$xls->generateXML('Biobank list');
}
/**
* Manages all models.
*/
public function actionAdmin()
{
$model = new Clipro('search');
$model->unsetAttributes();
// clear any default values
if (isset($_GET['Clipro'])) {
$model->attributes = $_GET['Clipro'];
}
if (isset($_GET['espe'])) {
// $this->render('ju',array('data'=>$model->search()->getdata()));
$modelito = new Clipro('search_');
$modelito->unsetAttributes();
// clear any default values
if (isset($_GET['Clipro'])) {
$modelito->attributes = $_GET['Clipro'];
}
$data = $modelito->search_()->getdata();
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'My Test Sheet');
$xls->addArray($data);
$xls->generateXML('my-test');
Yii::app()->end();
}
$this->render('admin', array('model' => $model));
}
public function actionPrintSearch()
{
$data[0] = array('ID', '姓','名','性别','籍贯','办公室','职位','个人邮箱','公司邮箱','公司电话','个人电话','个人微信','个人QQ');
$model = new Staff;
if(isset($_POST['ids'])){
foreach($_POST['ids'] as $id){
$arr = $model->find(array('condition'=>"id=$id"));
$data[] = array(
$arr->id,
$arr->name,
$arr->first,
$arr->gender,
$arr->hometown,
$arr->office,
$arr->position,
$arr->email,
$arr->comemail,
$arr->phone,
$arr->mobile,
$arr->wechat,
$arr->qq,
);
}
}
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'Staff_sheet');
$xls->addArray($data);
$xls->generateXML('All_Staff_Info_Sheet'.time());
}
public function actionPrintDonate($cid)
{
$cid = intval($cid);
$data[0] = array('定单ID','联系人','金额');
$tempArr = Order::model()->findAll(array('select'=>'id,cid,donate','condition'=>"cal_id=$cid and status=1 and donate<>0"));
foreach($tempArr as $temp){
$data[] = array($temp->id,$this->getContorById($temp->cid),$temp->donate);
}
$rand = date('Y-m-d',time()).mt_rand(0,999);
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'ordersheet');
$xls->addArray($data);
$xls->generateXML($rand."_DonatePrint");
exit;
}
public function actionExcel()
{
//
//
// $model=new Alumni('search');
// $data = array(
// 1 => array ('ลำดับ', 'Surname'),
// array('Schwarz', 'Oliver'),
// array('Test', 'Peter')
// );
//
$issueDataProvider = $_SESSION['Filtered_Excel'];
$i = 0;
unset($_SESSION['Filtered_Excel']);
//fix column header.
//Could have used something like this - $data[]=array_keys($issueDataProvider->data[0]->attributes);.
//But that would return all attributes which i do not want
$data[$i]['alumni_id'] = 'ลำดับ';
$data[$i]['alumni_group'] = 'ระดับ';
$data[$i]['alumni_no_en'] = 'รุ่นที่จบ (ภาษาอังกฤษ)';
$data[$i]['alumni_no_th'] = 'รุ่นที่จบ (ภาษาไทย)';
$data[$i]['name_en'] = 'ชื่อ-นามสกุล (ภาษาอังกฤษ)';
$data[$i]['name_th'] = 'ชื่อ-นามสกุล (ภาษาไทย)';
$data[$i]['sex_en'] = 'เพศ (ภาษาอังกฤษ)';
$data[$i]['sex_th'] = 'เพศ (ภาษาไทย)';
$data[$i]['image'] = 'รูปประจำตัว';
$data[$i]['major_en'] = 'สาขาวิชาที่จบ (ภาษาอังกฤษ)';
$data[$i]['major_th'] = 'สาขาวิชาที่จบ (ภาษาไทย)';
$data[$i]['campus_en'] = 'ศูนย์การศึกษา (ภาษาอังกฤษ)';
$data[$i]['campus_th'] = 'ศูนย์การศึกษา (ภาษาไทย)';
$data[$i]['position_en'] = 'ตำแหน่งงานปัจจุบัน (ภาษาอังกฤษ)';
$data[$i]['position_th'] = 'ตำแหน่งงานปัจจุบัน (ภาษาไทย)';
$data[$i]['desc_en'] = 'ประวัติโดยย่อ (ภาษาอังกฤษ)';
$data[$i]['desc_th'] = 'ประวัติโดยย่อ (ภาษาไทย)';
$i++;
//populate data array with the required data elements
foreach ($issueDataProvider->data as $issue) {
if ($issue['alumni_group'] == 'Master') {
$alumni_group = 'ปริญญาโท';
} else {
$alumni_group = 'ปริญญาเอก';
}
$AlumniNo = $this->loadModelAlumniNo($issue['alumni_no_id']);
$alumni_no_en = $AlumniNo->name_th;
$alumni_no_th = $AlumniNo->name_th;
$data[$i]['alumni_id'] = $issue['alumni_id'];
$data[$i]['alumni_group'] = $alumni_group;
$data[$i]['alumni_no_en'] = $alumni_no_en;
$data[$i]['alumni_no_th'] = $alumni_no_th;
$data[$i]['name_en'] = $issue['name_en'];
$data[$i]['name_th'] = $issue['name_th'];
$data[$i]['sex_en'] = $issue['sex'] == 'F' ? 'Female' : 'Male';
$data[$i]['sex_th'] = $issue['sex'] == 'F' ? 'หญิง' : 'ชาย';
$data[$i]['image'] = $issue['image'];
$data[$i]['major_en'] = $issue['major_en'];
$data[$i]['major_th'] = $issue['major_th'];
$data[$i]['campus_en'] = $issue['campus_en'];
$data[$i]['campus_th'] = $issue['campus_th'];
$data[$i]['position_en'] = $issue['position_en'];
$data[$i]['position_th'] = $issue['position_th'];
$data[$i]['desc_en'] = $issue['desc_en'];
$data[$i]['desc_th'] = $issue['desc_th'];
$i++;
}
$xls = new JPhpExcel('UTF-8', false, 'Export Alumni');
$xls->addArray($data);
$xls->generateXML('alumni_file');
//*** Insert Picture (2) ***//
}
public function actionPrintlist()
{
$data[0] = array('ID', '用户名','邮箱');
$model = new Member;
$criteria=new CDbCriteria;
$criteria->select = 'id,name,email';
if(isset($_POST['start']) && !empty($_POST['start'])){
$start = strtotime($_POST['start']);
$criteria->addCondition("createtime>=$start");
}
if(isset($_POST['stop']) && !empty($_POST['stop'])){
$start = strtotime($_POST['stop']);
$criteria->addCondition("createtime<=$start");
}
$members = $model->findAll($criteria);
foreach($members as $member){
$data[] = array($member->id,$member->name,$member->email);
}
Yii::import('application.extensions.phpexcel.JPhpExcel');
$xls = new JPhpExcel('UTF-8', false, 'Members_sheet');
$xls->addArray($data);
$xls->generateXML('All_Members_Email_Sheet');
}
