Web Development

ALTER PROCEDURE [dbo].[uspGetPivotedData]
AS
DECLARE @cols AS NVARCHAR(MAX),
    @query  AS NVARCHAR(MAX);
SET @cols = STUFF((SELECT distinct ',' + QUOTENAME(m.registration_date) 
            FROM Members m
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'')
set @query = 'SELECT TransactionID,
                AmountOwed,
				FullName,
				Gender,
				phone,
				EmailAddress,
				Address,
				EventYear, 
                Description,
				Reg_Fee
				 ' + @cols + ' from 
               (
                SELECT t.TransactionID, 
					 t.AmountOwed,
					 m.FullName,
                     m.EmailAddress,
					 m.Gender, 
					 m.Phone, 
                     m.Address,
				     t.EventYear, 
                     p.Description,					
					 Reg_Fee,
                     m.registration_date,
					 t.AmountPaid
                     from dbo.Transactions AS t INNER JOIN dbo.Members AS m ON t .MemberID = m.MemberID INNER JOIN
                     dbo.PaymentTypes AS p ON t .TypeID = p.PaymentTypeID
          ) x
            pivot 
            (
                max(AmountPaid)
                for registration_date in (' + @cols + ')
            ) p '
            EXECUTE sp_executesql @query

export class App
{
  id: number;
  name: string;
  description: string;
  isEnabled: boolean;
  shortName: string;
  displayOrder: number;
}

{"ID":1
,"Name":"Matterhorn User Management"
,"Description":"User and Role management for Matterhorn applications."
,"IsEnabled":true
,"ShortName":"MUM"
,"DisplayOrder":10}

getApplications(): Observable<App[]>
{
  let apiURL: string = this.baseUrl + 'usermanagement/applications/read';

  return this.http.get<App[]>(apiURL);
}

getApps(): void
{
  this.appsService.getApplications()
    .subscribe(data =>
    {
      this.apps = data.sort((a, b) => a.DisplayOrder - b.DisplayOrder);
    });

}

Hi My Website "stelleninfotech.com" is showing error.when we refresh it then its work properly.
Any Idea?

Displaying Error


Warning : opendir(cache/domains/): failed to open dir: No such file or directory in /var/www/html/cms/application/models/api_model.php on line 14

Warning : readdir() expects parameter 1 to be resource, boolean given in /var/www/html/cms/application/models/api_model.php on line 15

Notice : Undefined variable: domains in /var/www/html/cms/application/models/api_model.php on line 22

Warning : in_array() expects parameter 2 to be array, null given in /var/www/html/cms/application/models/api_model.php on line 22
bad

<form name="uf" method="POST" action="/WSD4RRR/somefile.do" enctype="multipart/form-data">
	<div style="background-color: #c6c6c6; padding: 5px">
		<span>Choose file:</span> <span> <input type="file" name="linkdoc" size="75" value=""></span><span><input type="submit" value="Send"></span>
	</div>
	<p style="color: red;">
</form></td>

<form name="uf" method="POST" action="https://original.site.com/WSD4RRR/somefile.do" enctype="multipart/form-data">
	<div style="background-color: #c6c6c6; padding: 5px">
		<span>Choose file:</span> <span> <input type="text" name="linkdoc"></span><span><input type="submit" value="Send"></span>
	</div>
	<p style="color: red;">
		
	</p>
</form>

input type="file"

input type="text"