Comments by Member 10685464

Member 10685464 25-Jun-14 2:38am View

i deleted old one. And this is a improved.But this is forum right and you got the answer at least hint that what should i do if u say like that then how we can post the questions from next time

Member 10685464 25-Jun-14 2:32am View

No actually, at that it didn't come & i urgently required so i post the question.And I just want it urgent

Member 10685464 25-Jun-14 2:14am View

actually in that post I am unable to post the question so I post another.

Member 10685464 25-Jun-14 2:09am View

Deleted

ohk and i have no deep knowledge about js. This is already written code. Actually i did't understand what i have to post so someone is asking for code so i post the code. Any way

if (mode === 'help') {
var ifr = document.createElement('iframe');
ifr.className = 'helpinfocontrol';
ifr.frameBorder = 0;
ifr.id = 'IFR_' + rnd;
document.body.appendChild(ifr);
ifr.anim = new LoadingAnimation("Dv_" + rnd);
if (document.attachEvent) { //IE
var that = ifr;
ifr.attachEvent('onload', function () { that.anim.Stop(); });
} else if (document.addEventListener) { //Firefox
var that = ifr;
ifr.addEventListener('load', function () { that.anim.Stop(); }, false);
} else {
ifr.onload = function () {
this.anim.Stop();
}
}
$(ifr).css({ width: wdt - 37, height: hgt - 37, left: lft + 20, top: tp + 15, 'position': 'absolute', 'z-index': 299998 });
ifr.src = url;
ifr.anim.Start();
}
function displayCanvas() {
$(canvas).css({ width: wdt, height: hgt, left: lft });
canvas.width = wdt;
canvas.height = hgt;
var ctx = canvas.getContext("2d");
ctx.clearRect(0, 0, wdt, hgt);
ctx.save();
roundRect(ctx, 11, 10, wdt - 22, hgt - 22, 10, true, true);
ctx.strokeStyle = '#878787';
ctx.beginPath();
ctx.lineWidth = 2;
ctx.moveTo(originx2, 25);
ctx.lineTo(originx1, 30);
ctx.lineTo(originx2, 35);
ctx.fill();
ctx.closePath();
ctx.stroke();
ctx.beginPath();
ctx.lineWidth = 2;
ctx.strokeStyle = '#ffffff';
ctx.moveTo(originx2, 26);
ctx.lineTo(originx2, 34);
ctx.closePath();
ctx.stroke();
ctx.save();
}
this is my code

Member 10685464 25-Jun-14 1:27am View

Deleted

Member 10685464 25-Jun-14 1:26am View

Deleted

ok,
var jqtoolTiphovering;
jQuery.fn.toolTip = function () {
var obj = $(this);
var args = (arguments[0]) ? arguments[0] : { "mode": "help" };
var successFn = arguments[1];
var mode = (args.mode) ? args.mode : 'help';
var lookup = (args.lookup) ? args.lookup : '';
var url = (args.url) ? args.url : '';
var wdtfactor = (args.size) ? args.size : 'medium';
var disable = (args.disable) ? args.disable : 'false';
var max = (args.MaxRecordsToFetch) ? args.MaxRecordsToFetch : 100;
var pagesize = (args.pagesize) ? args.pagesize : 10;
var objectToSet = (args.object) ? document.getElementById(args.object) : '';
var oricondition = (args.condition) ? args.condition : '';
var displayorder = (args.displayorder) ? args.displayorder : '';
var allowstar = (args.allowstar) ? args.allowstar : false;
if (displayorder != '') {
displayorder = displayorder.split(',');
}
var displayorderlen = displayorder.length;
var condition = '';
//clear controls
if (objectToSet) {
if (objectToSet != '' && objectToSet != undefined) {
objectToSet.controlarray = (args.controlarray) ? args.controlarray : '';
objectToSet.oldvalue = objectToSet.value;
if ($(objectToSet).hasClass('tooltipsearch') == false) {
$(objectToSet).unbind('blur');
$(objectToSet).bind('blur', function () {
var that = this;
if (that.value == '') {
clearControls(that);
} else {
if (that.oldvalue != that.value && that.value.indexOf('%') < 0 && ((that.value != '*' && allowstar == true) || allowstar == false)) {
generateCondition();
Netxert.APP.Web.NetxertAPP.getDynamicHelp(lookup, 2, min, max, that.value, condition, function (args) {
if (args != '[]') {
if (successFn) {
args = eval('(' + args + ')');
successFn(args[0]);
}
} else {
var rndtdid = 'td' + Math.ceil(Math.random() * 1000);
if (that.parentNode.parentNode.parentNode.parentNode.parentNode) {
that.parentNode.parentNode.parentNode.parentNode.parentNode.uniqueid = rndtdid;
var pnode = that.parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.getElementsByTagName('TD');
var msg = '';
for (var k = 0; k < pnode.length; k++) {
if (pnode[k + 1]) {
if (pnode[k + 1].uniqueid == rndtdid) {
msg = $(pnode[k]).find('span').filter(function () { return $(this).html() != '*'; }).first().html();
break;
}
}
}

alert('Invalid data entered for ' + msg.replace(':', ''));
clearControls(that);
that.value = '';
that.focus();
return false;
}
}
}, function (err) { if (err._message.indexOf('Authentication failed') >= 0) { window.location = '/SessionTimeOut.aspx'; } else { alert(err._message); } });
}
}
});
}

Member 10685464 20-Jun-14 1:17am View

No actually for we use customer id for getting row number only.

Member 10685464 16-Jun-14 5:45am View

i got the solution actually customer ID is nvarchar field in table so i am converting that field in integer.And now it's working

Member 10685464 16-Jun-14 4:08am View

Actually i am getting wrong records if i use row_number why it is happen plz help me.Means i am getting 1st record as 2nd means customer id=1 records show in customer id 2 . so what is problem i didn't understand please help me.

Member 10685464 16-Jun-14 3:29am View

Thanks but still it's not working

Member 10685464 16-Jun-14 3:08am View

declare @Company_Code int=5
SELECT distinct @Company_Code,
'bc'+ cast(row_number()over(order by customerID asc) as nvarchar(100))as BillCode,
isnull(AddressLine1,'') as AddressLine1,
isnull(AddressLine2,'') as AddressLine1,
isnull(City_Suburb,'') as City_Suburb,
isnull(StateAbbreviation,'') as StateAbbreviation,
Zip_Postcode,
CC.Country_Code,
Phone ,
Phone as phone_ext,
Email,
'' as Fax,
GETDATE() as create_date_time,
'SYSTEM' as create_user_id,
GETDATE() as last_update_date_time,
'SYSTEM' as last_update_user_id

from MTrackDataImport..rawCustomerSISU C

LEFT OUTER JOIN CD_country CC
ON (CC.Company_Code = @Company_Code
AND C.Country = CC.Country_Name)

this is my query

Member 10685464 16-Jun-14 2:59am View

I tried that one also but it didn't work

Member 10685464 6-Jun-14 3:20am View

i got the solution

Member 10685464 23-May-14 7:49am View

IF exists (SELECT * FROM sysobjects WHERE
id=object_id('usp_INV_get_InventoryActivity'))
DROP PROCEDURE usp_INV_get_InventoryActivity
GO

/*==========================================================================================
**
** FILE : usp_INV_get_InventoryActivity.sql
**
** Author :- JP/16-06-2009
** PURPOSE OF FILE :This procedure will INSERT or UPDATE INV_STOCK_TRANSACTION_HISTORY table
for the months WHEN transactions does not happen
**
** This Proc is executed by:
**
Modifications:
07 Feb 2013 : Riddhi R- Added case for OpeningBalance,ClosingBalance and EndingTotal.
17 Dec 2009 - Beena - Removed unnecessary code
14 Dec 2009 - Abhay - Defect ID 16 (Live Release)- For showing Return Quantity and Avg Return value
30 Sep 2009 - Beena Shah -Average Rate were not calculated properly
4th Sep 2009 - Beena Shah - Defect 181 - Show Transfer as a separate column for inv activity
28/08/2009 Beena Shah Added Total Adjustment value and also UPDATEd proc for right calculations
16/06/2009 Beena Shah Added Adjustment qty for closing balance
** =========================================================================================*/
CREATE PROCEDURE usp_INV_get_InventoryActivity
(
@Company_Code type_company_code,
@IPart_No INT --Company Code For Labor code
)

AS Begin

DECLARE @Inv_Precision INT,
@Currency Nvarchar(10)

SELECT @Inv_Precision=Inv_SET_Inventory_Precision ,
@Currency = Currency_Symbol
FROM cd_General_parameter G inner join CD_Currency C
On G.Gen_country_Code = C.Country_Code
And G.Company_Code = C.Company_Code
WHERE G.Company_Code=@Company_Code

SELECT
company_code,
CurrentMonth=datename(mm,convert(nvarchar(2),IMonth)+'/01/2000'), -- To get month name datename function needs date in format 'mm/dd/yyyy'
CurrentMonthNumeric=isnull(IMonth,''),
CurrentYear =IYear,

--opening qty
OpeningBalance = ISNULL(case when sum(OpeningQty) < 0 then 0 else sum(OpeningQty) end,0.0),

--Issue
IssuedQuantity= ISNULL(sum(issuedqty),0.0),
TotalIssuedValue= @Currency + ' ' + ISNULL(sum(TotalIssueValue),0.0) ,
AvgIssuedQuantity= @Currency + ' ' + STR(ISNULL(case when sum(issuedqty)=0 then Avg(AvgIssueRate)
else sum(TotalIssueValue)/sum(issuedqty)
end,0.0),30,@Inv_Precision),

--Receive
ReceivedQuantity=ISNULL(Sum(recqty),0.0),
TotalReceivedValue=@Currency + ' ' + STR(ISNULL(Sum(TotalRecValue),0.0),30,@Inv_Precision),
AvgReceivedQuantity=@Currency + ' ' + STR(ISNULL(case when sum(recqty)=0 then Avg(AvgRecRate)
else sum(TotalRecValue)/sum(recqty)
end,0.0),30,@Inv_Precision),

--Adjustment
AdjustmentQty=ISNULL(Sum(AdjustmentQty),0.0),
TotalAdjValue=@Currency + ' ' + STR(ISNULL(Sum(TotalAdjustmentValue),0.0),30,@Inv_Precision),
AvgAdjustmentRate=@Currency + ' ' + STR(ISNULL(case when sum(AdjustmentQty)=0 then Avg(AvgAdjustmentRate)
else sum(TotalAdjustmentValue)/sum(AdjustmentQty)
end,0.0),30,@Inv_Precision),

--Transfer
TransferedQty = ISNULL(sum( case When TransferedQty >= 0 then TransferedQty
else 0 end ),0.0),
TotalTransferValue=@Currency + ' ' + STR(ISNULL(sum(case When TransferedQty >= 0 then TotalTransferValue
else 0 end ),0.0),30,@Inv_Precision),
AvgTransferRate=@Currency + ' ' + STR(ISNULL(case when sum(case When TransferedQty >= 0 then TransferedQty
else 0 end )=0 then Avg(AvgTransferRate)
else sum(case When TransferedQty >= 0 then TotalTransferValue
else 0 end )/sum(case When TransferedQty >= 0 then Transfere

Member 10685464 15-May-14 1:54am View

thank u but i got the answer . it is because str as well as because of ltrim function also

Member 10685464 14-May-14 3:24am View

On_Hand_Quantity
9993.00
9970.00
996.00
99.00
99.00
980.00
98.00
98.00
975.00

this is output

Member 10685464 14-May-14 2:39am View

thank u but after using order by clause also it is not working

Member 10685464 28-Apr-14 7:07am View

actaully po_no,Item_no,line_item_seq_no are from po_master and po_item table respectively

Member 10685464 21-Apr-14 2:12am View

thank you for your response but its correct tag i use vb.net & i am validting the values using properties from bo

Member 10685464 21-Apr-14 1:53am View

it's blank validation i have another text box name purchase cost same as min qty i.e 9 textbox of minQty & 9 textbox of minQty if minqty is blank then validation for purchase cost & vice versa. for all the 9 textbox

Member 10685464 21-Apr-14 1:43am View

Thank u but i want to validate the values & i take these value from textboxes

Member 10685464 4-Apr-14 1:13am View

solved the question

Member 10685464 4-Apr-14 0:54am View

Thank you

Member 10685464 1-Apr-14 7:52am View

ok thanx,but i am totally new for using web services so can u explain in detail,please

Member 10685464 26-Mar-14 9:13am View

Error
Please log In
only this will come on page.
and Function written in java script. Jquery also used

<%@ Master Language="VB" AutoEventWireup="false" CodeBehind="Site.master.vb" Inherits="Netxert.APP.Portal.Site" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
<title>MTrack Portal</title>
<link href="/App_Themes/Portal/Portal.css" rel="stylesheet" type="text/css" />
<asp:ContentPlaceHolder ID="HeadContent" runat="server">
</head>
<body>
<div id="header">
<div class="titlebar">
<div id="CompanyName"><div class="left"></div><div class="right">Welcome <%=Netxert.APP.Security.SingletonSession.GetCurrenSession.UserName%>, <%=Netxert.APP.Security.SingletonSession.GetCurrenSession.CompanyName%></div></div>
</div>
<ul class="uppermenu">
<li>Sign Out</li>
<li>Contact Us</li>
<li>Material Return</li>
<li>Download</li>
<li>Catalog</li>
<li>My Account</li>
<li>Home</li>
</ul>
</div>

<form runat="server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" CombineScripts="false" runat="server" EnablePageMethods="true" ScriptMode="Release" >
<Scripts>
<asp:ScriptReference Path="~/Web/js/ProgressBar.js" />
</Scripts>

<asp:HiddenField ID="HdnMagentoURL" runat="server" />
<asp:HiddenField ID="HdnEmail" runat="server" />
<asp:image imageurl="/web/img/logo.png" runat="server" ID="ImgLogo" />
<div style="height:25px;"></div>
<asp:UpdatePanel runat="server" ID="updtmsg" UpdateMode="Always" >
<contenttemplate>
<table width="100%">
<tr>
<td align="center" >
<asp:Label runat="server" ID="lblErrMsg" ForeColor="Red">
<asp:Label runat="server" ID="lblSucessMsg" ForeColor="green">
</td>
</tr>
</table>

<asp:ContentPlaceHolder ID="MainContent" runat="server"/>
<div id="divProgress" runat="server" style="display:none; background-color:#ffffff; padding:10px 10px 10px 10px;font-size:13px;" align="center">
Processing your request.<br />Please wait....
</div>
<asp:modalpopupextender runat="server" id="mdl" OkControlID="btncancel" CancelControlID="btnok" targetcontrolid="divProgress" popupcontrolid="divProgress"
onokscript="showConfirm(this);"
oncancelscript="javascript:return cancelClick();" backgroundcssclass="modalBackground">

<div id="DvFilterToggle"></div>
<table width="98%" cellpadding="0" cellspacing="0" border="0" style="border-left: solid 0px #000000;
this is my code

Member 10685464 26-Mar-14 1:40am View

'Error Please log in' i got this error when i am loading page in IE11.

Member 10685464 25-Mar-14 6:26am View

please reply me...

Member 10685464 25-Mar-14 5:32am View

<head runat="server">
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
<title>MTrack Portal</title>
<link href="/App_Themes/Portal/Portal.css" rel="stylesheet" type="text/css" />
<asp:ContentPlaceHolder ID="HeadContent" runat="server">
</head>
<body>
<div id="header">
<div class="titlebar">
<div id="CompanyName"><div class="left"></div><div class="right">Welcome <%=Netxert.APP.Security.SingletonSession.GetCurrenSession.UserName%>, <%=Netxert.APP.Security.SingletonSession.GetCurrenSession.CompanyName%></div></div>
</div>
<ul class="uppermenu">
<li>Sign Out</li>
<li>Contact Us</li>
<li>Material Return</li>
<li>Download</li>
<li>Catalog</li>
<li>My Account</li>
<li>Home</li>
</ul>
</div>

<form runat="server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" CombineScripts="false" runat="server" EnablePageMethods="true" ScriptMode="Release" >
<Scripts>
<asp:ScriptReference Path="~/Web/js/ProgressBar.js" />
</Scripts>

<asp:HiddenField ID="HdnMagentoURL" runat="server" />
<asp:HiddenField ID="HdnEmail" runat="server" />
<asp:image imageurl="/web/img/logo.png" runat="server" ID="ImgLogo" />
<div style="height:25px;"></div>
<asp:UpdatePanel runat="server" ID="updtmsg" UpdateMode="Always" >
<contenttemplate>
<table width="100%">
<tr>
<td align="center" >
<asp:Label runat="server" ID="lblErrMsg" ForeColor="Red">
<asp:Label runat="server" ID="lblSucessMsg" ForeColor="green">
</td>
</tr>
</table>

<asp:ContentPlaceHolder ID="MainContent" runat="server"/>
<div id="divProgress" runat="server" style="display:none; background-color:#ffffff; padding:10px 10px 10px 10px;font-size:13px;" align="center">
Processing your request.<br />Please wait....
</div>
<asp:modalpopupextender runat="server" id="mdl" OkControlID="btncancel" CancelControlID="btnok" targetcontrolid="divProgress" popupcontrolid="divProgress"
onokscript="showConfirm(this);"
oncancelscript="javascript:return cancelClick();" backgroundcssclass="modalBackground">

<div id="DvFilterToggle"></div>
<table width="98%" cellpadding="0" cellspacing="0" border="0" style="border-left: solid 0px #000000;
border-right: solid 1px #000000; display:none;">
<tr>
<td valign="top" style="background-image: url(~/web/img/bg.gif); height: 400px; background-repeat: repeat-x;
padding: 0px 10px 10px 10px;">
<div style="height: 35px;">

</div>
<asp:Button runat="server" ID="btnok" style="display:none;" />
<asp:Button runat="server" ID="btncancel" style="di

Member 10685464 25-Mar-14 3:13am View

i used same but dont know where is problem
<li>Catalog</li>; this is my href link & call in js function
function openMagentoURL(mode) {
----
if (mode == 'catalog') {
uri = hdn + '/customer/account/login/email/' + document.getElementById('ctl00_HdnEmail').value + '/returnurl/catalogs';
ifr.style.display = '';
}else{some code}
}
$('#ifrMagento').css({ 'width': $(document).width(), 'height': $(document).height() - 80, 'left': 0, 'top': 50 });
ifr.src = uri;

please help me out

Comments by Member 10685464 (Top 29 by date)