15seconds

비동기 파일전송    ajaxfileupload.js

<script type=”text/javascript” src=”/resources/js/ajaxfileupload.js”></script>

function ajaxFileUpload(){

jQuery.ajaxFileUpload({

url:”/userListUpload”,

secureuri:false,

fileElementId:”fileData”,

dataType:”json”,

data:{departmentId:departmentId},

success:function(data, status){

//success function

},

error:function(data, status, e){

//fail function

}

});

}

—-Today

SELECT GETDATE() ‘Today’

—-Yesterday

SELECT DATEADD(d,-1,GETDATE()) ‘Yesterday’

–Start of Current Day

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0) ‘Start of Current Day’

–End of Current day

SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),1)) ‘End of Current day’

–Start of Yesterday

SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-1) ‘Start of Yesterday’

–End of Yesterday

SELECT DATEADD(ms,-3,DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)) ‘End of Yesterday’

–First day of week by ISO

SELECT DATEADD(dd,7*(DATEDIFF(dd,’1973-01-01′,’2015-01-04′)/7),’1973-01-01′) ‘First day of ISO Week’

—-First Day of Current Week

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),0) ‘First Day of Current Week’

—-Last Day of Current Week

SELECT DATEADD(wk,DATEDIFF(wk,0,GETDATE()),6) ‘Last Day of Current Week’

—-First Day of Last Week

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),0) ‘First Day of Last Week’

—-Last Day of Last Week

SELECT DATEADD(wk,DATEDIFF(wk,7,GETDATE()),6) ‘Last Day of Last Week’

—-First Day of Current Month

SELECT DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0) ‘First Day of Current Month’

—-Last Day of Current Month

SELECT DATEADD(ms,- 3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE())+1,0))) ‘Last Day of Current Month’

—-First Day of Last Month

SELECT DATEADD(mm,-1,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0)) ‘First Day of Last Month’

—-Last Day of Last Month

SELECT DATEADD(ms,-3,DATEADD(mm,0,DATEADD(mm,DATEDIFF(mm,0,GETDATE()),0))) ‘Last Day of Last Month’

—-First Day of Current Quarter

SELECT DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0) ‘First Day of Current Quarter’

—-First Day of Current Year

SELECT DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0) ‘First Day of Current Year’

—-Last Day of Current Year

SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE())+1,0))) ‘Last Day of Current Year’

—-First Day of Last Year

SELECT DATEADD(yy,-1,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0)) ‘First Day of Last Year’

—-Last Day of Last Year

SELECT DATEADD(ms,-3,DATEADD(yy,0,DATEADD(yy,DATEDIFF(yy,0,GETDATE()),0))) ‘Last Day of Last Year’ <font color=”#111111″ face=”Segoe UI, Arial, sans-serif”><span style=”font-size: 14px; white-space: normal;”>

</span></font>

2. 소셜커머스를 하는 목표를 분명히 하라.

3. 핵심 성공 요인을 규명하라.

4 플랫폼 믹스를 하고, 플랫폼 별 전술을 수립하라.

5. 고객 참여를 설계하라.

6. 보상을 설계하라.

7. 영향력 있는 소수자와 커뮤니티를 형성하라.

8. 보조 마케팅 수단 및 홍보 채널을 검토하라.

9. 인력, 투자, 개발 계획을 세워라.

10. ROI 측정 설계를 하라.

11. 실행하라.

12. 점검, 피드백, 전략의 수정을 반복하라.

비즈니스 모델소셜쇼핑, 프라이빗쇼핑클럽, F-Commerce, 소셜커머스애플리케이션, 소셜커머스 커뮤니티, 오픈마켓, 딜어그리게이터, B2B 서비스 등SNS 연동 방식SNS 링크형, 소셜웹형, SNS몰형, 오프라인 연동형, 디바이스 연동형 등소셜커머스 플랫폼홈페이지, 블로그, 트위터, 페이스북, 미투데이, 포스퀘어, 오프라인, 디바이스 등