$compile(scope.getTemplate("SOME HTML"))(scope);
$('#templateParent').append(scope.template);

In Angular (2+), you cannot directly compile HTML strings like $compile in AngularJS. Instead, Angular encourages a component-based approach for rendering dynamic content. Here's how you can achieve a similar functionality:

Angular Conversion

AngularJS Code:

$compile(scope.getTemplate("SOME HTML"))(scope);
$('#templateParent').append(scope.template);

Angular (2+) Equivalent:

To dynamically add HTML content, follow these steps:

---

Step 1: Component-Based Approach

Create a Reusable Dynamic Component:

import { Component, Input } from '@angular/core';

@Component({
 selector: 'app-dynamic-template',
 template: `<div [innerHTML]="template"></div>`,
})
export class DynamicTemplateComponent {
 @Input() template: string = '';
}

This component will render dynamic HTML passed as an input.

---

Step 2: Insert the Dynamic Component

Use ViewContainerRef to Add the Component Dynamically:

import {
 Component,
 ViewChild,
 ViewContainerRef,
 ComponentFactoryResolver,
 AfterViewInit,
} from '@angular/core';

@Component({
 selector: 'app-root',
 template: `<div id="templateParent" #templateParent></div>`,
})
export class AppComponent {
 @ViewChild('templateParent', { read: ViewContainerRef }) container!: ViewContainerRef;

 constructor(private resolver: ComponentFactoryResolver) {}

 addDynamicTemplate(html: string) {
   // Resolve the dynamic component
   const factory = this.resolver.resolveComponentFactory(DynamicTemplateComponent);

   // Create the component in the container
   const componentRef = this.container.createComponent(factory);

   // Pass the dynamic HTML to the component
   componentRef.instance.template = html;
 }

 // Example usage
 ngOnInit() {
   const dynamicHtml = `<p>This is dynamically inserted HTML!</p>`;
   this.addDynamicTemplate(dynamicHtml);
 }
}

---

Explanation:

1. DynamicTemplateComponent:

Handles rendering of the dynamic HTML using Angular's [innerHTML] binding

$filter('filter')(this.claimAmendList, { reqNo: this.claimAmendList[i].reqNo  }, true)[0];

In Angular (2+), you don't have a built-in $filter service as in AngularJS. Instead, you can achieve the same functionality using JavaScript's array methods like filter. Here's the equivalent conversion of the given AngularJS code:

AngularJS Code:

$filter('filter')(this.claimAmendList, { reqNo: this.claimAmendList[i].reqNo }, true)[0];

Converted Angular Code:

this.claimAmendList.filter(item => item.reqNo === this.claimAmendList[i].reqNo)[0];

Explanation:

$filter('filter') in AngularJS is replaced with JavaScript's native Array.prototype.filter method in Angular.

The third argument (true) in AngularJS $filter('filter') ensures strict equality, which is the default behavior of === in JavaScript.

This direct conversion avoids creating custom pipes or components and uses standard TypeScript/JavaScript syntax.

<?php
function containsSpecialCharacters($text) {
   // Define a regex pattern for special characters
   $pattern = '/[^a-zA-Z0-9\s]/';
   
   // Check if the text contains any special characters
   if (preg_match($pattern, $text)) {
       return false;
   }
   
   return true;
}

// Example usage
$text = "HelloWorld123"; // This will return true
var_dump(containsSpecialCharacters($text));

$textWithSpecialChars = "Hello@World!"; // This will return false
var_dump(containsSpecialCharacters($textWithSpecialChars));
?>

removeDuplicatesFromOptions(are: any[]): any[] {
 return are.map(item => {
   if (item.Options && Array.isArray(item.Options)) {
     item.Options = item.Options.filter((option, index, self) =>
       index === self.findIndex(o => o.Id === option.Id && o.name === option.name)
     );
   }
   return item;
 });
}

If you don't want to use a function and instead directly implement the logic, you can write the code inline as follows:

Inline Code:

const Are = [
 {
   Item1: 'aaa',
   Item2: 'bbb',
   Options: [
     { Id: 1, name: 'name 1' },
     { Id: 1, name: 'name 1' },
     { Id: 2, name: 'name 2' },
   ]
 },
 {
   Item1: 'ccc',
   Item2: 'ddd',
   Options: [
     { Id: 1, name: 'name 1' },
     { Id: 3, name: 'name 3' },
     { Id: 3, name: 'name 3' },
   ]
 }
];

// Inline logic to remove duplicates from Options
const updatedAre = Are.map(item => {
 if (item.Options && Array.isArray(item.Options)) {
   item.Options = item.Options.filter((option, index, self) =>
     index === self.findIndex(o => o.Id === option.Id && o.name === option.name)
   );
 }
 return item;
});

console.log(updatedAre);

// Output:
// [
//   {
//     Item1: 'aaa',
//     Item2: 'bbb',
//     Options: [
//       { Id: 1, name: 'name 1' },
//       { Id: 2, name: 'name 2' },
//     ]
//   },
//   {
//     Item1: 'ccc',
//     Item2: 'ddd',
//     Options: [
//       { Id: 1, name: 'name 1' },
//       { Id: 3, name: 'name 3' },
//     ]
//   }
// ]

Explanation:

1. Are.map(): Iterates through each object in the Are array.

2. Check for Options: Ensures Options exists and is an array.

3. Deduplication Logic:

Use filter to retain only unique objects.

Compare the current object with others using findIndex to ensure only the

import { Injectable } from '@angular/core';

@Injectable({
 providedIn: 'root',
})
export class DateService {
 /**
  * Calculates the number of months between the current date and the provided date.
  * @param inputDate A string or Date object representing the date to compare.
  * @returns Number of months between the current date and the provided date.
  */
 calculateMonths(inputDate: Date | string): number {
   const currentDate = new Date();
   const targetDate = new Date(inputDate);

   if (isNaN(targetDate.getTime())) {
     throw new Error('Invalid date format');
   }

   const yearsDifference = currentDate.getFullYear() - targetDate.getFullYear();
   const monthsDifference = currentDate.getMonth() - targetDate.getMonth();

   return yearsDifference * 12 + monthsDifference;
 }
}

Using CSP nonces in MediaWiki is a good way to secure scripts and styles without completely blocking inline code. Here’s a detailed guide on how to implement and manage CSP nonces in MediaWiki.

1. What is a CSP Nonce?

A nonce ("number used once") is a randomly generated token that is added to each script or style tag. The server generates a unique nonce for each page load and includes it in the CSP header. Browsers will only allow inline scripts/styles if they have a matching nonce.

Example of a Nonce in a CSP Header

Content-Security-Policy: script-src 'self' 'nonce-ABC123';

Example of an Inline Script with a Nonce

<script nonce="ABC123">    console.log('This script is allowed!'); </script>

2. Implementing CSP Nonces in MediaWiki

Step 1: Generate a Nonce in LocalSettings.php

Modify LocalSettings.php to generate a random nonce for each request:

$wgHooks['BeforePageDisplay'][] = function ( &$out, &$skin ) {    $nonce = bin2hex(random_bytes(16)); // Generates a random 32-character nonce    $out->getRequest()->setHeader( 'X-CSP-Nonce', $nonce ); // Store in the response header    $GLOBALS['wgCSPNonce'] = $nonce; // Store globally for use in templates }; $wgCSPHeader = [    'default-src' => [ "'self'" ],    'script-src'  => [ "'self'", "'nonce-$wgCSPNonce'" ],    'style-src'   => [ "'self'", "'nonce-$wgCSPNonce'" ], ];

This dynamically sets a new nonce for every page request.

Step 2: Use the Nonce in Templates and Extensions

Now, you need to apply the nonce to your inline scripts and styles.

A. Adding Nonce to Inline Scripts

Instead of writing:

<script>    alert('Inline script running!'); </script>

Use:

<script nonce="<?= $GLOBALS['wgCSPNonce']; ?>">    alert('Inline script running!'); </script>

B. Adding Nonce to Inline Styles

Instead of:

<style>    body { background: #f4f4f4; } </style>

Use:

<style nonce="<?= $GLOBALS['wgCSPNonce']; ?>">    body { background: #f4f4f4; } </style>

Step 3: Pass the Nonce to MediaWiki Hooks

If you're using MediaWiki hooks to inject scripts, you need to pass the nonce dynamically.

A. Adding a Nonce in a Skin or Extension

Modify your skin’s PHP file (e.g., skins/MySkin.php):

$wgHooks['OutputPageBeforeHTML'][] = function ( &$out, &$text ) {    $nonce = $GLOBALS['wgCSPNonce'];    $text .= '<script nonce="' . htmlspecialchars($nonce) . '">console.log("Nonce added");</script>'; };

B. Adding a Nonce in JavaScript Injected via Hooks

If an extension uses inline JavaScript, modify it like this:

$wgHooks['BeforePageDisplay'][] = function ( &$out, &$skin ) {    $nonce = $GLOBALS['wgCSPNonce'];    $out->addHeadItem( 'custom-script', '<script nonce="' . htmlspecialchars($nonce) . '">console.log("Safe script!");</script>' ); };

3. Testing & Debugging CSP Nonces

A. Check Nonce in Browser Developer Tools

Open your site in Chrome/Firefox.

Press F12 > Console.

Look for CSP errors (they will tell you if a script was blocked).

Check the Network tab > Click on the page request > Headers > Look for X-CSP-Nonce.

B. Use CSP Report-Only Mode for Testing

Before fully enforcing CSP, test it using Report-Only Mode:

$wgCSPHeaderReportOnly = [    'default-src' => [ "'self'" ],    'script-src'  => [ "'self'", "'nonce-$wgCSPNonce'" ],    'style-src'   => [ "'self'", "'nonce-$wgCSPNonce'" ], ];

This logs violations without blocking them.

C. Debug CSP Violations

You can set up a CSP violation reporting URL:

$wgCSPReportUri = 'https://yourdomain.com/csp-report.php';

Then, create csp-report.php to log violations:

<?php $input = file_get_contents("php://input"); file_put_contents("csp-violations.log", $input . PHP_EOL, FILE_APPEND); ?>

Check csp-violations.log for blocked scripts and styles.

4. Alternative: Using mw.config to Store Nonce

Instead of PHP, you can set the nonce in JavaScript:

$wgHooks['MakeGlobalVariablesScript'][] = function ( &$vars, &$out ) {    $vars['cspNonce'] = $GLOBALS['wgCSPNonce']; };

Then, use it in JavaScript:

const nonce = mw.config.get('cspNonce'); document.write(`<script nonce="${nonce}">console.log("Safe script!");</script>`);

Final Thoughts

Best Practice: Move as many scripts as possible to MediaWiki:Common.js or ResourceLoader modules.

Use Nonces: For any remaining inline scripts/styles, dynamically generate and attach a nonce.

Test with CSP Report-Only Mode before enforcing it site-wide.

Would you like help debugging your CSP setup, or do you have specific inline scripts causing issues?

$wgHooks['BeforePageDisplay'][] = function ( &$out, &$skin ) {
   $nonce = bin2hex(random_bytes(16)); // Generates a random 32-character nonce
   $GLOBALS['wgCSPNonce'] = $nonce; // Store nonce globally

   // Set CSP header including the nonce
   $out->addExtraHeader(
       "Content-Security-Policy",
       "default-src 'self'; script-src 'self' 'nonce-$nonce'; style-src 'self' 'nonce-$nonce';"
   );
};

Short Longer Text Button Click Me Very Long Button Text Example Button

function isValid(str) {
 return /^(?=.*[a-zA-Z])[a-zA-Z0-9\s\W_]+$/.test(str);
}

SELECT
   tc.table_name,
   kcu.column_name
FROM 
   information_schema.table_constraints AS tc
JOIN 
   information_schema.key_column_usage AS kcu
   ON tc.constraint_name = kcu.constraint_name
   AND tc.constraint_schema = kcu.constraint_schema
LEFT JOIN 
   pg_indexes AS idx
   ON idx.schemaname = tc.constraint_schema
   AND idx.tablename = tc.table_name
   AND idx.indexdef ILIKE '%' || kcu.column_name || '%'
WHERE 
   tc.constraint_type = 'FOREIGN KEY'
   AND tc.constraint_schema = 'css'
   AND idx.indexname IS NULL;

SELECT
   tc.table_name AS source_table,
   kcu.column_name AS fk_column,
   ccu.table_name AS referenced_table
FROM 
   information_schema.table_constraints AS tc
JOIN 
   information_schema.key_column_usage AS kcu
   ON tc.constraint_name = kcu.constraint_name
   AND tc.constraint_schema = kcu.constraint_schema
JOIN 
   information_schema.constraint_column_usage AS ccu
   ON tc.constraint_name = ccu.constraint_name
   AND tc.constraint_schema = ccu.constraint_schema
LEFT JOIN 
   pg_indexes AS idx
   ON idx.schemaname = tc.constraint_schema
   AND idx.tablename = tc.table_name
   AND idx.indexdef ILIKE '%' || kcu.column_name || '%'
WHERE 
   tc.constraint_type = 'FOREIGN KEY'
   AND tc.constraint_schema = 'css'
   AND idx.indexname IS NULL;

removeOptionByName(parentArray: any[], targetName: string): void {
 parentArray.forEach(parent => {
   if (parent.options && Array.isArray(parent.options)) {
     const index = parent.options.findIndex(option => option.name === targetName);
     if (index !== -1) {
       parent.options.splice(index, 1);
     }
   }
 });
}

removeProjectById(arr: { projectid: number }[], idToRemove: number): { projectid: number }[] {
 return arr.filter(project => project.projectid !== idToRemove);
}

let Arr = [{ projectid: 111 }, { projectid: 222 }, { projectid: 333 }];
Arr = this.removeProjectById(Arr, 222);
console.log(Arr);  // Output: [ { projectid: 111 }, { projectid: 333 } ]

WITH survey_data AS (
   SELECT 
       survey_id,
       project_id,
       survey_title,
       survey_status_id,
       financialyear_from,
       half_year,
       survey_resend_date,
       survey_sent_date,
       survey_response_received_date,
       is_survey_offline,
       survey_type_id,
       updated_ts
   FROM css.survey_header
   WHERE survey_status_id BETWEEN 2000 AND 11000
   AND financialyear_from||'-'||financialyear_from + 1 ||' '||half_year = '2024-2025 H1'
),
dissatisfier_counts AS (
   SELECT 
       survey_id,
       COUNT(CASE WHEN tcs_satisfier_indicator = 'Dissatisfier' THEN 1 END) AS count_dissatisfiers
   FROM css.survey_css_header
   GROUP BY survey_id
)

SELECT DISTINCT 
   d.id_seq AS parentdeliveryunitid,
   d.du_name::character varying AS parentdeliveryUnitName,
   dl.du_name AS deliveryunitname,
   gd.gdc_name AS gdc,
   ip.parent_description AS ou,
   c.name AS accountname,
   proj.client_id AS accountid,
   proj.project_id AS projectid,
   proj.project_name AS projectname,
   proj.current_status AS projectstatus,
   srv_css_hd.preferred_proj_name AS preferredprojectname,
   srv_hd.survey_title AS cssName,
   COALESCE(srv_css_hd.tcsindex, -1) AS csipercentage,
   srv_hd.id AS surveyid,
   srv_hd.survey_id AS ccsid,
   eng.at_projgrpid AS engagementId,
   eng.at_classification AS engagementComplexity,
   CASE 
       WHEN srv_css_hd.tcsindex IS NULL THEN ' '
       WHEN proj.current_status = 'Closed' THEN 
           CASE 
               WHEN rcs.status_id IS NULL THEN 'No'
               WHEN rcs.status_id NOT IN (4,5) THEN 'No' 
               ELSE 'Yes' 
           END
       WHEN dc.count_dissatisfiers > 0 THEN 'Yes'
       ELSE 'No'
   END AS apricotMandatoryStatus,
   (srv_hd.financialyear_from || '-'|| (srv_hd.financialyear_from+1))::character varying AS financialyear,
   srv_hd.half_year AS halfyear,
   st.survey_type_name AS surveytype,
   (COALESCE(clmem.first_name, ' ') || COALESCE(clmem.middle_name, ' ') || COALESCE(clmem.last_name, ' '))::varchar AS customerrepresentative,
   srv_css_hd.tcsform AS cssFormal,
   cap.css_applicability_flag AS cssapplicability,
   COALESCE(srv_hd.survey_resend_date, srv_hd.survey_sent_date) AS requestDate,
   srv_hd.survey_response_received_date AS responseDate,
   CASE 
       WHEN ss.survey_status_name = 'SENT' THEN 
           CASE WHEN srv_hd.is_survey_offline THEN 'SENT (offline)' ELSE 'SENT' END
       WHEN ss.survey_status_name = 'RECEIVED' THEN 
           CASE WHEN srv_hd.is_survey_offline THEN 'RECEIVED (offline)' ELSE 'RECEIVED' END
       ELSE ss.survey_status_name 
   END AS cssstatus,
   (SELECT DISTINCT srv.link_status FROM css.survey_link srv WHERE srv.survey_id = srv_hd.survey_id) AS linkstatus,
   f.freezingflag AS frozenstatus,
   to_date('','DD Mon YYY') AS frozendate,
   CASE  
       WHEN rcs.status_id IS NOT NULL THEN
           CASE 
               WHEN rcs.status_id = 1 THEN 'Initiated'
               WHEN rcs.status_id = 2 THEN 'Analysed'
               WHEN rcs.status_id IN (3,4) THEN 'Planned'
               WHEN rcs.status_id = 5 THEN 'Closed'
               ELSE (SELECT status FROM css.rca_status_mst WHERE id=rcs.status_id)
           END
       WHEN srv_hd.survey_status_id=3000 THEN 'Not Initiated'
       ELSE 'Not Applicable'
   END AS apricotstatus,
   rcs.id AS apricotid,
   NULL,
   srv_hd.survey_status_id AS cssstatusid,
   srv_hd.updated_ts AS updatedts
FROM css.css_applicable_projects cap
JOIN survey_data srv_hd ON srv_hd.project_id = cap.project_id
JOIN css.projects proj ON proj.project_id = srv_hd.project_id
JOIN css.deliveryunits d ON proj.delivery_unit_id = d.id AND d.du_type_id = proj.deliveryunit_type_id
LEFT JOIN css.deliveryunits dl ON dl.id = proj.sub_du_id
LEFT JOIN css.gdcmst gd ON gd.gdc_code = proj.operational_dc
LEFT JOIN css.ip_master ip ON ip.id = proj.ip_id
LEFT JOIN css.clients c ON c.id = proj.client_id
LEFT JOIN css.survey_types_mst st ON st.survey_type_id = srv_hd.survey_type_id
LEFT JOIN css.survey_status ss ON ss.survey_status_id = srv_hd.survey_status_id
LEFT JOIN css.rca_sources rs ON rs.source_id = srv_hd.survey_id
LEFT JOIN css.survey_freezing_info f ON f.du_id = proj.delivery_unit_id
   AND f.du_type_id = proj.deliveryunit_type_id
   AND f.financialyearfrom = srv_hd.financialyear_from
   AND f.yearhalf = srv_hd.half_year
LEFT JOIN css.t_upp_proj_group_map engmap ON engmap.at_projectid = srv_hd.project_id
LEFT JOIN css.t_upp_project_group eng ON eng.at_projgrpid = engmap.at_projgrpid
LEFT JOIN css.rcas rcs ON rcs.id = rs.rca_id
JOIN css.survey_css_header srv_css_hd ON srv_css_hd.survey_id = srv_hd.survey_id AND srv_hd.project_id = srv_css_hd.project_id
JOIN css.client_members_new clmem ON clmem.id = srv_css_hd.contact_person_id
LEFT JOIN dissatisfier_counts dc ON dc.survey_id = srv_hd.survey_id;

WITH 
survey_data AS (
   SELECT * FROM css.survey_header
   WHERE survey_status_id BETWEEN 2000 AND 11000
   AND financialyear_from||'-'||financialyear_from + 1 ||' '||half_year = '2024-2025 H1'
),
dissatisfier_counts AS (
   -- From survey_css_header (TCS dissatisfiers)
   SELECT survey_id, COUNT(*) AS count_dissatisfiers
   FROM css.survey_css_header
   WHERE tcs_satisfier_indicator = 'Dissatisfier' AND tcsindex IS NOT NULL
   GROUP BY survey_id
   
   UNION ALL
   
   -- From survey_responses (TCS dissatisfiers)
   SELECT survey_id, COUNT(*) AS count_dissatisfiers
   FROM css.survey_responses
   WHERE tcs_satisfier_indicator = 'Dissatisfier'
   GROUP BY survey_id
   
   UNION ALL
   
   -- From survey_css_header (OFI dissatisfiers when conditions met)
   SELECT survey_id, COUNT(*) AS count_dissatisfiers
   FROM css.survey_css_header
   WHERE ofi_satisfier_indicator = 'Dissatisfier'
   AND tcsindex IS NOT NULL AND tcsform = 'N'
   GROUP BY survey_id
),
aggregated_dissatisfiers AS (
   SELECT survey_id, SUM(count_dissatisfiers) AS total_dissatisfiers
   FROM dissatisfier_counts
   GROUP BY survey_id
)

SELECT DISTINCT 
   d.id_seq AS parentdeliveryunitid,
   d.du_name::character varying AS parentdeliveryUnitName,
   dl.du_name AS deliveryunitname,
   gd.gdc_name AS gdc,
   ip.parent_description AS ou,
   c.name AS accountname,
   proj.client_id AS accountid,
   proj.project_id AS projectid,
   proj.project_name AS projectname,
   proj.current_status AS projectstatus,
   srv_css_hd.preferred_proj_name AS preferredprojectname,
   srv_hd.survey_title AS cssName,
   COALESCE(srv_css_hd.tcsindex, -1) AS csipercentage,
   srv_hd.id AS surveyid,
   srv_hd.survey_id AS ccsid,
   eng.at_projgrpid AS engagementId,
   eng.at_classification AS engagementComplexity,
   CASE 
       WHEN srv_css_hd.tcsindex IS NULL THEN ' '
       WHEN proj.current_status = 'Closed' THEN 
           CASE 
               WHEN rcs.status_id IS NULL THEN 'No'
               WHEN rcs.status_id NOT IN (4,5) THEN 'No'
               ELSE 'Yes'
           END
       ELSE 
           CASE 
               WHEN (SELECT COALESCE(total_dissatisfiers, 0) 
                    FROM aggregated_dissatisfiers 
                    WHERE survey_id = srv_hd.survey_id) > 0 
               THEN 'Yes' 
               ELSE 'No' 
           END
   END AS apricotMandatoryStatus,
   -- Rest of your columns...
FROM css.css_applicable_projects cap
JOIN survey_data srv_hd ON srv_hd.project_id = cap.project_id
-- Rest of your joins...

import { Component, NgZone, OnDestroy } from '@angular/core';

@Component({
 selector: 'app-speech-to-text',
 templateUrl: './speech-to-text.component.html',
 styleUrls: ['./speech-to-text.component.css']
})
export class SpeechToTextComponent implements OnDestroy {
 transcript = '';
 isRecording = false;
 recognition: any;

 constructor(private ngZone: NgZone) {
   const SpeechRecognition = (window as any).SpeechRecognition || (window as any).webkitSpeechRecognition;

   if (SpeechRecognition) {
     this.recognition = new SpeechRecognition();
     this.recognition.continuous = true;
     this.recognition.interimResults = true;
     this.recognition.lang = 'en-US';

     this.recognition.onresult = (event: any) => {
       let finalTranscript = '';
       for (let i = event.resultIndex; i < event.results.length; i++) {
         const transcriptChunk = event.results[i][0].transcript;
         if (event.results[i].isFinal) {
           finalTranscript += transcriptChunk + ' ';
         } else {
           finalTranscript += transcriptChunk;
         }
       }
       // Use NgZone to trigger change detection
       this.ngZone.run(() => {
         this.transcript = finalTranscript;
       });
     };

     this.recognition.onerror = (event: any) => {
       console.error('Speech recognition error', event.error);
     };
   } else {
     alert('Speech recognition is not supported in this browser.');
   }
 }

 startRecording(): void {
   if (this.recognition) {
     this.recognition.start();
     this.isRecording = true;
   }
 }

 stopRecording(): void {
   if (this.recognition) {
     this.recognition.stop();
     this.isRecording = false;
   }
 }

 ngOnDestroy(): void {
   this.stopRecording();
 }
}

<div class="container">
 <h2>Real-Time Speech to Text</h2>

 <button (click)="startRecording()" [disabled]="isRecording">???? Start</button>
 <button (click)="stopRecording()" [disabled]="!isRecording">???? Stop</button>

 <div class="transcript">
   <h3>Transcript:</h3>
   <p>{{ transcript }}</p>
 </div>
</div>