public function _exportToCSV($status){ $columnHeader = ""; $setData = ''; $findAll = ImportUsers::model()->findAll("status = $status"); if(!empty($findAll)){ foreach($findAll as $objData){ $rowData = ''; $value = '"' . $objData->title1 . '"' . "\t"; $value .= '"' . $objData->title2 . '"' . "\t"; $value .= '"' . $objData->title3 . '"' . "\t"; $rowData .= $value; $setData .= trim($rowData) . "\n"; } } $fileName = 'output.csv'; header("Content-type: application/octet-stream"); header("Content-Disposition: attachment; filename = $fileName"); header('Content-Transfer-Encoding: binary'); header("Pragma: no-cache"); header("Expires: 0"); echo chr(255).chr(254).iconv("UTF-8", "UTF-16LE//IGNORE", $setData . "\n"); exit(); }

1: Change Collection Field To “utf8_persian_ci” 2: In Query SELECT * FROM campaigns ORDER BY title COLLATE utf8_persian_ci 3: In Yii Framework $academics = Academic::find() ->where([ ‘organization_id’ => $_POST[‘organization’], ‘academic_year_id’ => $_POST[‘academicYear’], ‘base_id’ => $_POST[‘base’], ‘field_id’ => $_POST[‘field’] ]) ->andWhere([‘IN’,’status’,$arrayStatus]) ->joinWith(‘profiles p’)

async findOne(findOneTurnOfTimePlanDetailDto: FindOneTurnOfTimePlanDetailDto ){ let filter = { _id: findOneTurnOfTimePlanDetailDto.planDetailId…

let aggregateTotal = []; let aggregateMatch = {}; if (searchServiceDto.hasOwnProperty('code')) { Object.assign(aggregateMatch, { codeStr: new RegExp(searchServiceDto.code.toString()), }); } aggregateTotal.push( { $addFields : { codeStr: { $toString: '$code' } } } ) aggregateTotal.push({ $match: aggregateMatch, }); aggregateTotal.push( { $project : { codeStr: 0 } } )

1: use :: https://wajihaabid.medium.com/downloading-data-in-excel-format-with-nest-js-4a0a859bf430 excel.controller.ts import {Controller, Get, Header, Res} from '@nestjs/common'; import { ExcelService } from './excel.service'; import {Response} from "express"; @Controller('excel') export class ExcelController { constructor(private readonly excelService: ExcelService) {} @Get('/download') @Header('Content-Type', 'text/xlsx') async downloadReport(@Res() res: Response) { let data = […

1: install Node https://www.digitalocean.com/community/tutorials/how-to-set-up-a-node-js-application-for-production-on-ubuntu-20-04 curl -sL https://deb.nodesource.com/setup_16.x -o nodesource_setup.sh nano nodesource_setup.sh bash nodesource_setup.sh apt install nodejs node -v npm -v apt install build-essential npm audit 2:install mongo https://www.digitalocean.com/community/tutorials/how-to-install-mongodb-on-ubuntu-20-04

1: Error internal/modules/cjs/loader.js:905 throw err; ^ Error: Cannot find module ‘webpack’ Require stack: 2: https://www.educative.io/edpresso/how-to-fix-error-cannot-find-module-webpack npm install webpack npm link webpack Enjoy

1: name:: batch_for_dump.bat 2: @ECHO OFF for /f “skip=1” %%i in (‘wmic os get localdatetime’) do if not defined fulldate set fulldate=%%i set year=%fulldate:~0,4% set month=%fulldate:~4,2% set day=%fulldate:~6,2% set foldername=%year%_%month%_%day% md C:\data\db\%foldername% mongodump — host=*.*.*.* — port=*** — username root — password ****— db mom_*** — authenticationDatabase admin -o C:\data\db\%foldername% PAUSE

Documentation | NestJS - A progressive Node.js framework Compodoc is a documentation tool for Angular applications. Since Nest and Angular share similar project and code…docs.nestjs.com npm i -D @compodoc/compodoc npx @compodoc/compodoc -p tsconfig.json -s