db.embryosTransfer.find().forEach(function (doc1) { var doc2 = db.users.findOne({ _id: doc1.patientUserId }); if (doc2 != null) { let date1 = new Date(doc2.dateOfBirth); let date2 = new Date(doc1.date); let diffTime = Math.abs(date2 - date1); let diffDays = Math.ceil(diffTime / (1000 * 60 * 60 * 24)); let diffYears = Math.floor(diffTime / (1000 * 60 * 60 * 24 * 365)); let daysLastYear = diffDays - ( diffYears * 365); if( daysLastYear>= 180){ diffYears +=1; } db.embryosTransfer.update({'_id' : doc1._id}, [ { $set: { "age" :diffYears} } ]); } });

Http Concepts What kind of attacks does SSL prevent? https://venafi.com/machine-identity-basics/the-most-common-ssl-and-tls-attacks/ Man-in-the-Middle (MITM) Duty HTML: Easy Transfer Html files Request Header Request Body Response Header Response Body Request Header: VERB = Method = Request Type GET à Request the specified resource Provide me with a resource from the server POST à…

db.medicalRecords.updateMany({$and:[{legalVisits: { $exists: true, $ne: [] }},{“legalVisits.legalVisitType”:”donated_egg”}]},{$set:{ “legalVisits.$[].legalVisitType” : “Ali”}}) db.medicalRecords.findOne({$and:[{forensicMedicineVisits: { $exists: true, $ne: [] }},{“forensicMedicineVisits.forensicMedicineVisitType”:”donated_egg”}]})

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