+91 9422537131 | info@adhvik.online |
Sports Sagaa | Simplicity Global Services Register
01 Jan 20 by Administrator 41
ALTER TABLE Account ADD ALink varchar(3500)
GO
ALTER VIEW [dbo].[vAccount]
AS
SELECT a1.CompanyId, a1.AccountId, a1.AccountTypeId, a1.ARoleIds, a1.PAccountId, a1.ACode, a1.OCode, a1.ATitle, a1.Gender, a1.FName, a1.MName, a1.LName, a1.BirthDate, a1.JoinDate, a1.Age, a1.Email, a1.Mobile, a1.Password,
a1.BloodGroup, a1.DeptId, a1.DesgId, a1.MaritalStatus, a1.Nationality, a1.AAddress, a1.StatusOfResidential, a1.LocalityCAddress, a1.CCountry, a1.CState, a1.TownCAddress, a1.CDistrict, a1.CPinCode, a1.PermanentAddress,
a1.LocalityPAddress, a1.PCountry, a1.PState, a1.TownPAddress, a1.PDistrict, a1.PPinCode, a1.PhoneR, a1.PhoneO, a1.ProofOfAddress, a1.ProofOfIdentity, a1.LinkedTo, a1.FatherName, a1.MotherName, a1.GuardianName,
a1.IncTaxSlab, a1.RouteId, a1.ContactPerson, a1.AColor, a1.OpenDate, a1.OpenBal, a1.OpenDrCr, a1.AcNote, a1.ADImage, a1.AImages, a1.EduId, a1.OccupationId, a1.Caste, a1.SubCaste, a1.Disability, a1.DisabilityPer,
a1.DisabilityI, a1.AadharNo, a1.AadharI, a1.VotingCardNo, a1.VotingCardI, a1.RashanCard, a1.RashanI, a1.PanCardNo, a1.PanCardI, a1.PassportNo, a1.PassportIssueDt, a1.PassportExpDt, a1.PassportIssueAt, a1.PassportI,
a1.GSTTIN, a1.GSTTINI, a1.CGeoLocation, a1.PGeoLocation, a1.Facebook, a1.Instagram, a1.Twitter, a1.Youtube, a1.LinkedIn, a1.Social1, a1.Social2, a1.Social3, a1.PassOutYear, a1.AStandard, a1.AStatus, a1.AShowWeb, a1.ALink,
ISNULL(a1.FName, N'') + N' ' + ISNULL(a1.MName, N'') + N' ' + ISNULL(a1.LName, N'') AS FullName, ISNULL(a1.FName, N'') + N' ' + ISNULL(a1.LName, N'') AS FLName, g7.GTitle AS g7GTitle, g7.GShort AS g7GShort,
g7.SortOrder AS g7SortOrder, g10.GTitle AS g10GTitle, g10.GShort AS g10GShort, g10.SortOrder AS g10SortOrder, ISNULL(a1.FName, N'') + N' ' + ISNULL(a1.MName, N'') + N' ' + ISNULL(a1.LName, N'') + N': ' + ISNULL(a1.Mobile,
N'') AS FullMName, g80.GTitle AS g80GTitle, g80.GShort AS g80GShort, g80.SortOrder AS g80SortOrder, g9.GTitle AS g9GTitle, g9.GShort AS g9GShort, g9.SortOrder AS g9SortOrder
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(ADImage AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iADImage
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(AImages AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iAImages
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(AadharI AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iAadharI
FROM dbo.Account AS a1 LEFT OUTER JOIN
dbo.generalsettings AS g9 ON a1.DeptId = g9.GId AND a1.CompanyId = g9.Companyid AND g9.GTypeId = 9 LEFT OUTER JOIN
dbo.generalsettings AS g80 ON a1.EduId = g80.GId AND a1.CompanyId = g80.Companyid AND g80.GTypeId = 80 LEFT OUTER JOIN
dbo.generalsettings AS g10 ON a1.CompanyId = g10.Companyid AND a1.DesgId = g10.GId AND g10.GTypeId = 10 LEFT OUTER JOIN
dbo.generalsettings AS g7 ON a1.CompanyId = g7.Companyid AND a1.OccupationId = g7.GId AND g7.GTypeId = 7
Tags:
Share Post
03 Jan 20 by Administrator 41
ALTER TABLE Item ADD ILink varchar(3500)
ALTER TABLE Item ADD IDImages varchar(7000)
ALTER TABLE generalsettings ADD GLink varchar(3500)
GO
ALTER VIEW [dbo].[vItem]
AS
SELECT i1.ILink,i1.CompanyId, i1.ItemId, i1.PItemId, i1.TypeId, i1.ItemName, i1.ShortName, i1.RatePerUnit, i1.TotalOn, i1.ICategory1, i1.ICategory2, i1.ICategory3, i1.ICategory4, i1.ICategory5, i1.ExpireInDays, i1.SortOrder, i1.iLength, i1.iWidth,
i1.iHeight, i1.MeasureUnit, i1.UQty, i1.UUnit, i1.OQty, i1.OUnit, i1.ICategory, i1.IF1, i1.IF2, i1.IF3, i1.IF4, i1.IF5, i1.IF6, i1.VATPer, i1.VATIncl, i1.ItemNote, i2.ItemName AS PItemName, g0.GTitle AS IGType, g1.GTitle AS IC1Type,
g2.GTitle AS IC2Type, g3.GTitle AS IC3Type, g4.GTitle AS IC4Type, g5.GTitle AS IC5Type, i2.OQty AS POQty
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(i1.IDImages AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iIDImages
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(i1.IImages AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iIImages
FROM dbo.Item AS i1 LEFT OUTER JOIN
dbo.generalsettings AS g5 ON i1.CompanyId = g5.Companyid AND g5.GTypeId = 19 AND i1.ICategory5 = g5.GId LEFT OUTER JOIN
dbo.generalsettings AS g4 ON i1.CompanyId = g4.Companyid AND g4.GTypeId = 18 AND i1.ICategory4 = g4.GId LEFT OUTER JOIN
dbo.generalsettings AS g3 ON i1.CompanyId = g3.Companyid AND g3.GTypeId = 17 AND i1.ICategory3 = g3.GId LEFT OUTER JOIN
dbo.generalsettings AS g2 ON i1.CompanyId = g2.Companyid AND g2.GTypeId = 16 AND i1.ICategory2 = g2.GId LEFT OUTER JOIN
dbo.Item AS i2 ON i1.CompanyId = i2.CompanyId AND i1.PItemId = i2.ItemId LEFT OUTER JOIN
dbo.generalsettings AS g1 ON i1.CompanyId = g1.Companyid AND i1.ICategory1 = g1.GId AND g1.GTypeId = 15 LEFT OUTER JOIN
dbo.generalsettings AS g0 ON i1.CompanyId = g0.Companyid AND i1.TypeId = g0.GId AND g0.GTypeId = 14
GO
CREATE VIEW vgeneralsettings
AS
SELECT a.Companyid, a.GTypeId, a.GId, a.PGId, a.GTitle, a.GShort, a.Value1, a.Value2, a.Value3, a.GColor, a.GImages, a.FImages, a.GStatus, a.SortOrder, a.GLink, b.GTitle AS TGTitle, b.GShort AS TGShort
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(a.GImages AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iGImages
, ISNULL((SELECT STUFF(( SELECT ',' + ImageDir + REPLACE(ImageFileName, ImageFileType, '--100' + ImageFileType) FROM FileManager WHERE CompanyId=0 AND ImageType=0 AND CHARINDEX(N',' + LTRIM(RTRIM(ImageId)) + ',', N',' + REPLACE(CAST(a.FImages AS nvarchar(max)),N' ',N'') + ',') > 0 FOR XML PATH('')), 1, 1, '') AS XYList), '../../img/aim.png') AS iFImages
FROM dbo.generalsettings AS a INNER JOIN
dbo.generalsettings AS b ON a.Companyid = b.Companyid AND a.GTypeId = b.GId AND b.GTypeId = 0
Tags:
Share Post
03 Jan 20 by Administrator 41
CREATE VIEW vLinks AS
SELECT 0 AS srt, 'vposts2' AS tbl, PTypeId, PostId, PTitle, PLink FROM posts
UNION
SELECT 1 AS srt, 'vgeneralsettings' AS tbl, GTypeId, GId, GTitle, GLink FROM generalsettings
UNION
SELECT 2 AS srt, 'vAccount' AS tbl, AccountTypeId, AccountId, FName, ALink FROM Account
UNION
SELECT 3 AS srt, 'vItem' AS tbl, TypeId,ItemId, ItemName, ILink FROM Item
Tags:
Share Post
by 333
dtuser = dataset of user query for login check return userid = Accountid of current login user usertypeid = AccountTypeId of current login user username = First NAme and LastName of current login u
24 Aug 19 by Administrator 205
There are few web safe fonts which can be widely used in websites. Arial Helvetica Times New Roman Times Courier New Courier Verdana Georgia Palatino Garamond Bookman Comic Sans MS Treb
02 Dec 19 by Administrator 84
Classes This is an example of how html is rendered. With the following options you can change almost every class the way you want <div class="owl-carousel owl-theme owl-loaded"> <div c
23 Sep 19 by 77
https://developers.facebook.com/docs/facebook-login/web && <script>window.fbAsyncInit = function() {FB.init({appId : '1208343976013791',cookie : true,xfbml : true,version : 'v4.0'});F
03 Jan 20 by Administrator 41
CREATE VIEW vLinks ASSELECT 0 AS srt, 'vposts2' AS tbl, PTypeId, PostId, PTitle, PLink FROM postsUNIONSELECT 1 AS srt, 'vgeneralsettings' AS tbl, GTypeId, GId, GTitle, GLink FROM generalsettingsUNIONS
12570

We are simpliy creative. We create stunning identities for our clients that people recommand.

Login
×
Remember me
Forgot password?