로즈루미

그냥 윈도우에서,

1. C:\Program Files\Android\Android Studio. 로 이동
2. jbr directory 다복사
3. jre director 다붙이기

그다음 flutter doctor 돌리면 해당이슈 없어짐

jdk 환경변수 설정도 잘해야함.

이슈없다 빡셌다...

https://stackoverflow.com/questions/51100401/typescript-image-import

출처(링크)

For react-native

create global.d.ts file on project root folder and just add next lines there

declare module '*.png' {
  const value: import('react-native').ImageSourcePropType;
  export default value;
}

master로 push를 하였고 기본 브랜치가 master로 잡혀있음
main 브랜치에 미적용 단계여서 
[Git] There isn’t anything to compare
이렇게 나옴
이전엔 default가 master였음
마스터 슬레이브라는 용어가 흑인 문화에서 인종차별적 발언이란 문제로 
master에서 main으로 바뀜... 썩을.... -_-;;

해결방법
git checkout master
git branch main master -f
git checkout main
git push origin main -f

출처: https://jeongkyun-it.tistory.com/128

https://www.w3big.com/ko/jsp/jstl-function-escapexml.html

이런식으로도 쌉가능
$('div.aaa > ul > li[class=bbb] input[name=ccc]')

<form:input cssStyle="width:calc(100%-200px); ime-mode:active;" cssClass="aaa">

$('tr.orders th').click(function(){
...
});

함수안에다가 제이쿼리 클릭함수 쓰는것도 가능.
function init(){
$('aaa').click(function(){
.....
});
}

$('p.title')
.each(function(){
$(this)
.children('a')
.click(function(){
$('#form1 input[name=aaa]').val($(this).parent().children('span').eq(0).text());
})
})
$('p.aaa a img').click(function(){
....
});
https://junghn.tistory.com/m/entry/jQuery-jQuerygrep-%EC%82%AC%EC%9A%A9-%EB%B0%A9%EB%B2%95

$('#aaa').append(val);
$('#aaa').prepend(val);
$($('#aaa').get(ccc)).after(sss);

var form=$('<form</form>');
form.attr({
method: ...
action: ...
});
in javascript, also can use ${pageContext.request.contextPath}
form.append($('<input/>', {type:'hidden', name: 'aaa', value: sss}));
form.appendTo('body');
form.submit();
var aaa = function(){
return {init: init}
function init(){
....
}
}();

$('button[name=aaa]').click(function(){});
<fmt:formatDate value="<%=new java.util.Date()%>" pattern="yyyyMMddHHmmss"/>

$.each($('input[name="aaa"]:radio'), function(index, el){
$(el).prop('disabled', true);
$(el).parent('aaa').find('ddd').text("");
$(el).closet('label > span[name="aaa"]').text("");
});
var aaa = $('input[name="aaa"]:checked').data('ccc');
<input type="radio" name="aaa" data-ccc="111">

window.addEventListener('message', function(e){
...
});
window message
window.postMessage
iframe
https://ohgyun.com/532

https://developer.mozilla.org/en-US/docs/Web/API/Window/message_event

document.body.offsetWidth
window.screen.height

$('#id .classname').click(function(){
var aaa = $(this).attr('name');
var _top = $('aaa').offset().top - 100;
$('html, body').animate({scrollTop._top}, 1000);
$('.aaa').children('li').each(function(i){
if(_cnt > i){$(this).attr('style', 'display:none;');}
$('.aaa').children('li').eq(0).attr('aaa', 0).focus();
$('.aaa').children('li').length;
$('#id1, #id2..').keypress(function(e){});
});
blur keyup도 있음
});

https://m.blog.naver.com/PostView.naver?isHttpsRedirect=true&blogId=dbjina&logNo=221124483583

$(document).on('click', '[data-action="aaa"]', function(e){});
$.trim(aaa);
$('#a').removeClass('b').addClass('c');
$('#a').find('.a').removeAttr('b');
$('body').removeClass addClass etc...
eval(functionname+'()');
$aaa.find('.a').text('aaa');
function close(data){
eval(aaa+"(data)");
}
const b = [
<c:forEach items='${aaa}' var='bbb' varStatus='ccc'>
{
ddd: '${eee}'
}
<c:if test='${!status2.last}'>,</c:if>
</c:forEach>
]
자바스크립트 안에서도 c태그 사용가능...
function aaa(){
$('#aaa').change((e)=>{...});
}

requestScope 관련
https://erim1005.tistory.com/m/entry/JSP-forward%EB%90%9C-%ED%8E%98%EC%9D%B4%EC%A7%80%EC%97%90%EC%84%9C-requestgetRequestURI-%EC%82%AC%EC%9A%A9%ED%95%98%EA%B8%B0

$(window).width()/2;
$(`\${aaa} li.on`).position().left;
$('#aaa').scrollLeft(100-50);
그리고 이런식의 구성도 가능
let a = $("<a>");
a.attr('href', 'aaa');
a.attr('class', 'bbb');

var aform = $('<form></form>');
aform.attr("method","post");
aform.attr("action","<c:out value=''/>");
aform.attr("name","aform");
aform.append($('<input>', {type: 'hidden', name: ..., id: ..., value: ...}));
aform.appendTo('body');
aform.submit();

서버스탭에서 더블클릭

 Open launch configuration 클릭

밑에 빨간글씨 추가 입력 수 어플라이

-Dcatalina.base="D:\ERPR\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0" -Dcatalina.home="D:\dongbang\01.BulkManagement\setting\apache-tomcat-9.0.56-windows-x64\apache-tomcat-9.0.56" -Dwtp.deploy="D:\ERPR\workspace\.metadata\.plugins\org.eclipse.wst.server.core\tmp0\wtpwebapps" --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED -Xmx768m -Xss256m -XX:MaxPermSize=256m

java.lang.IllegalStateException: LifecycleProcessor not initialized - call 'refresh' before invoking lifecycle methods via the context: Root WebApplicationContext: startup date [Fri Jul 15 10:49:28 KST 2022]; root of context hierarchy
at org.springframework.context.support.AbstractApplicationContext.getLifecycleProcessor(AbstractApplicationContext.java:359) ~[spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.doClose(AbstractApplicationContext.java:890) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.close(AbstractApplicationContext.java:843) [spring-context-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.web.context.ContextLoader.closeWebApplicationContext(ContextLoader.java:579) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextDestroyed(ContextLoaderListener.java:115) [spring-web-4.0.9.RELEASE.jar:4.0.9.RELEASE]
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4816) [catalina.jar:9.0.56]
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5477) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.stop(LifecycleBase.java:257) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:187) [catalina.jar:9.0.56]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) [catalina.jar:9.0.56]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) [catalina.jar:9.0.56]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.56]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) [?:?]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) [catalina.jar:9.0.56]
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.56]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) [catalina.jar:9.0.56]
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) [catalina.jar:9.0.56]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.56]
at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) [?:?]
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) [catalina.jar:9.0.56]
at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:263) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.56]
at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.56]
at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:927) [catalina.jar:9.0.56]
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.56]
at org.apache.catalina.startup.Catalina.start(Catalina.java:772) [catalina.jar:9.0.56]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) [bootstrap.jar:9.0.56]
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:476) [bootstrap.jar:9.0.56]
2022-07-15 10:49:35,232 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1830302e: defining beans [org.springframework.aop.config.internalAutoProxyCreator,serviceAspect,Account001Service,account002Service,account003Service,account004Service,account005Service,account006Service,account007Service,account008Service,account009Service,account010Service,account011Service,account012Service,account013Service,account014Service,account015Service,account016Service,account017Service,account018Service,account019Service,account020Service,account021Service,account022Service,account023Service,account024Service,account025Service,account026Service,account027Service,account028Service,account029Service,account030Service,budget001Service,budget002Service,code001Service,code002Service,code003Service,code004Service,code005Service,code006Service,code007Service,funds001Service,funds002Service,funds003Service,funds004Service,funds005Service,funds006Service,funds007Service,funds008Service,funds009Service,funds010Service,funds011Service,funds012Service,funds013Service,funds014Service,funds015Service,funds016Service,funds017Service,funds018Service,jasan001Service,jasan002Service,jasan003ervice,jasan004Service,jasan005Service,jasan006Service,jasan007Service,jasan008Service,magam001Service,magam002Service,magam003Service,magam004Service,magam005Service,attachService,carService,commonService,attendance001Service,attendance002Service,attendance003Service,attendance004Service,attendance005Service,attendance006Service,attendance007Service,master001Service,master002Service,master003Service,master004Service,master005Service,master006Service,master007Service,master008Service,master009Service,master010Service,master011Service,master012Service,payment001Service,payment002Service,payment003Service,payment004Service,payment005Service,payment006Service,payment007Service,payment008Service,payment009Service,retirement001Service,retirement002Service,retirement003Service,retirement004Service,standard002Service,standard003Service,standard004Service,standard005Service,standard006Service,standard007Service,standard008Service,standard009Service,trans001Service,trans002Service,approvalService,slipService,taxService,noim31006Service,noim31007Service,noim32006Service,noim33006Service,noim33007Service,noim41001Service,noim41006Service,noim51006Service,noim51007Service,noim53006Service,noim53007Service,noim54006Service,noim61006Service,noim61007Service,noim63001Service,noim63002Service,noim63005Service,noim63006Service,noim63007Service,noim63012Service,noim63014Service,noim63016Service,noim63018Service,noim63019Service,noim67006Service,noim71001Service,noim71002Service,noim71003Service,noim71004Service,noim71005Service,noim71006Service,noim71007Service,noim71012Service,noim71013Service,noim71014Service,noim71015Service,noim71017Service,noim71018Service,noim71019Service,noim71020Service,noim71021Service,noim71022Service,noim91006Service,noim91007Service,noimBusan001Service,noimCom001Service,noimCom002Service,noimCom003Service,noimCom004Service,noimCom005Service,noimCom007Service,noimCom008Service,noimCom009Service,noimCom010Service,noimCom011Service,noimCom012Service,noimCom013Service,noimCom014Service,noimCom015Service,noimCom016Service,noimCom017Service,noimCom018Service,noimCom019Service,noimCom020Service,noimCom021Service,noimCom022Service,noimCom023Service,noimCom024Service,noimCom025Service,noimCom026Service,noimCom027Service,noimCom028Service,noimCom029Service,process001Service,process002Service,process003Service,process004Service,process005Service,process006Service,process007Service,process008Service,product001Service,product002Service,product003Service,product004Service,product005Service,product006Service,product007Service,product009Service,balance001Service,balance002Service,balance003Service,balance004Service,balance005Service,balance006Service,balance007Service,balance008Service,purchase001Service,purchase002Service,purchase003Service,purchase004Service,purchase005Service,sales001Service,sales002Service,sales003Service,sales004Service,sales005Service,sales006Service,sales014Service,sales015Service,sales016Service,statement001Service,statement002Service,statement003Service,inout001Service,inout002Service,inout003Service,inout004Service,inout005Service,inout006Service,inout007Service,inout008Service,inout009Service,move001Service,move002Service,move003Service,move004Service,stock001Service,stock002Service,stock003Service,stock004Service,stock005Service,stock006Service,stock007Service,stock008Service,stock009Service,stock010Service,stock011Service,system001Service,system002Service,system003Service,system004Service,system005Service,system006Service,system007Service,system008Service,system009Service,system010Service,system011Service,system012Service,system013Service,system014Service,system015Service,system020Service,system030Service,system031Service,system901Service,system998Service,system999Service,DBSExceptionHandler,org.springframework.context.annotation.internalConfigurationAnnotationProcessor,org.springframework.context.annotation.internalAutowiredAnnotationProcessor,org.springframework.context.annotation.internalRequiredAnnotationProcessor,org.springframework.context.annotation.internalCommonAnnotationProcessor,globals,messageSource,multipartResolver,uploadDirResource,dataSource,dataSourceSpied,sqlSessionFactory,sqlSession,org.mybatis.spring.mapper.MapperScannerConfigurer#0,birtView,engine,excelView,springSecurityFilterChain,securityContextPersistenceFilter,concurrentSessionFilter,webAsyncManagerIntegrationFilter,headerWriterFilter,hstsHeaderWriter,frameOptionsWriter,logoutFilter,logoutSuccessHandler,logoutHandler,usernamePasswordAuthenticationFilter,authenticationManager,daoAuthenticationProvider,passwordEncoder,anonymousAuthenticationProvider,userDetailsService,authenticationSuccessHandler,authenticationFailureHandler,basicAuthenticationFilter,basicAuthenticationEntryPoint,requestCacheAwareFilter,securityContextHolderAwareRequestFilter,rememberMeAuthenticationFilter,rememberMeServices,rememberMeAuthenticationProvider,tokenRepository,anonymousAuthenticationFilter,sessionManagementFilter,securityContextRepository,invalidSessionStrategy,sessionStrategy,sessionRegistry,exceptionTranslationFilter,authenticationEntryPoint,accessDeniedHandler,filterSecurityInterceptor,securityMetadataSource,accessDecisionManager,roleVoter,roleHierarchy,hierarchy,webExpressionVoter,expressionHandler,authenticatedVoter,runAsManager,runAsAuthenticationProvider,csrfFilter,org.springframework.transaction.annotation.AnnotationTransactionAttributeSource#0,org.springframework.transaction.interceptor.TransactionInterceptor#0,org.springframework.transaction.config.internalTransactionAdvisor,transactionManager,transactionAdvice,requiredtransaction,org.springframework.aop.support.DefaultBeanFactoryPointcutAdvisor#0,org.springframework.context.annotation.ConfigurationClassPostProcessor.importAwareProcessor,org.springframework.context.annotation.ConfigurationClassPostProcessor.enhancedConfigurationProcessor,Account001Mapper,account002Mapper,account003Mapper,account004Mapper,account005Mapper,account006Mapper,account007Mapper,account008Mapper,account009Mapper,account010Mapper,account011Mapper,account012Mapper,account013Mapper,account014Mapper,account015Mapper,account016Mapper,account017Mapper,account018Mapper,account019Mapper,account020Mapper,account021Mapper,account022Mapper,account023Mapper,account024Mapper,account025Mapper,account026Mapper,account027Mapper,account028Mapper,account029Mapper,account030Mapper,budget001Mapper,budget002Mapper,code001Mapper,code002Mapper,code003Mapper,code004Mapper,code005Mapper,code006Mapper,code007Mapper,funds001Mapper,funds002Mapper,funds003Mapper,funds004Mapper,funds005Mapper,funds006Mapper,funds007Mapper,funds008Mapper,funds009Mapper,funds010Mapper,funds011Mapper,funds012Mapper,funds013Mapper,funds014Mapper,funds015Mapper,funds016Mapper,funds017Mapper,funds018Mapper,Jasan001Mapper,jasan002Mapper,jasan003Mapper,jasan004Mapper,jasan005Mapper,jasan006Mapper,jasan007Mapper,jasan008Mapper,magam001Mapper,magam002Mapper,magam003Mapper,magam004Mapper,magam005Mapper,attachMapper,commonMapper,attendance001Mapper,attendance002Mapper,attendance003Mapper,attendance004Mapper,attendance005Mapper,attendance006Mapper,attendance007Mapper,master001Mapper,master002Mapper,master003Mapper,master004Mapper,master005Mapper,master006Mapper,master007Mapper,master008Mapper,master009Mapper,master010Mapper,master011Mapper,master012Mapper,payment001Mapper,payment002Mapper,payment003Mapper,payment004Mapper,payment005Mapper,payment006Mapper,payment007Mapper,payment008Mapper,payment009Mapper,retirement001Mapper,retirement002Mapper,retirement003Mapper,retirement004Mapper,standard002Mapper,standard003Mapper,standard004Mapper,standard005Mapper,standard006Mapper,standard007Mapper,standard008Mapper,standard009Mapper,trans001Mapper,trans002Mapper,approvalMapper,slipMapper,noim32006Mapper,noim41001Mapper,noim41006Mapper,noim63001Mapper,noim63002Mapper,noim63003Mapper,noim63004Mapper,noim63005Mapper,noim63006Mapper,noim63007Mapper,noim63012Mapper,noim63014Mapper,noim63016Mapper,noim63018Mapper,noim63019Mapper,noim71001Mapper,noim71002Mapper,noim71003Mapper,noim71004Mapper,noim71005Mapper,noim71006Mapper,noim71007Mapper,noim71012Mapper,noim71013Mapper,noim71014Mapper,noim71015Mapper,noim71017Mapper,noim71018Mapper,noim71019Mapper,noim71020Mapper,noim71021Mapper,noim71022Mapper,noim91007Mapper,noimBusan001Mapper,noimCom001Mapper,noimCom002Mapper,noimCom003Mapper,noimCom004Mapper,noimCom005Mapper,noimCom007Mapper,noimCom008Mapper,noimCom009Mapper,noimCom010Mapper,noimCom011Mapper,noimCom012Mapper,noimCom013Mapper,noimCom014Mapper,noimCom015Mapper,noimCom016Mapper,noimCom017Mapper,noimCom018Mapper,noimCom020Mapper,noimCom021Mapper,noimCom022Mapper,noimCom023Mapper,noimCom024Mapper,noimCom025Mapper,noimCom026Mapper,noimCom027Mapper,noimCom028Mapper,noimCom029Mapper,noimDailyRegistrationUnionMapper,noimMagamMapper,noimSlipMapper,process001Mapper,process002Mapper,process003Mapper,process004Mapper,process005Mapper,process006Mapper,process007Mapper,process008Mapper,product001Mapper,product002Mapper,product003Mapper,product004Mapper,product005Mapper,product006Mapper,product007Mapper,product009Mapper,balance001Mapper,balance002Mapper,balance003Mapper,balance004Mapper,balance005Mapper,balance006Mapper,balance007Mapper,balance008Mapper,purchase001Mapper,purchase002Mapper,purchase003Mapper,purchase004Mapper,purchase005Mapper,sales001Mapper,sales002Mapper,sales003Mapper,sales004Mapper,sales005Mapper,sales006Mapper,sales014Mapper,sales015Mapper,sales016Mapper,statement001Mapper,statement002Mapper,statement003Mapper,inout001Mapper,inout002Mapper,inout003Mapper,inout004Mapper,inout005Mapper,inout006Mapper,inout007Mapper,inout008Mapper,inout009Mapper,move001Mapper,move002Mapper,move003Mapper,move004Mapper,stock001Mapper,stock002Mapper,stock003Mapper,stock004Mapper,stock005Mapper,stock006Mapper,stock007Mapper,stock008Mapper,stock009Mapper,stock010Mapper,stock011Mapper,system001Mapper,system002Mapper,system003Mapper,system004Mapper,system005Mapper,system006Mapper,system007Mapper,system008Mapper,system009Mapper,system010Mapper,system011Mapper,system012Mapper,system013Mapper,system014Mapper,system015Mapper,system020Mapper,system030Mapper,system031Mapper,system901Mapper,system998Mapper,system999Mapper]; root of factory hierarchy
2022-07-15 10:49:35,232 DEBUG [org.springframework.beans.factory.support.DefaultListableBeanFactory] Retrieved dependent beans for bean 'net.sf.log4jdbc.tools.Log4JdbcCustomFormatter#1c15d2ef': [dataSource]
2022-07-15 10:49:35,232 DEBUG [org.springframework.beans.factory.support.DisposableBeanAdapter] Invoking destroy method 'close' on bean with name 'dataSourceSpied'
7월 15, 2022 10:49:35 오전 org.apache.coyote.AbstractProtocol start
INFO: 프로토콜 핸들러 ["http-nio-8080"]을(를) 시작합니다.
7월 15, 2022 10:49:35 오전 org.apache.catalina.startup.Catalina start
INFO: 서버가 [14762] 밀리초 내에 시작되었습니다.

#migration은 꼭하자!! 

(models.py 변경후 재시작 시 안하면 python manage.py 실행할 때, 오류남)
python manage.py makemigrations
python manage.py migrate

yarn build 하려는데 글제목과 같은 에러가 나면 

cmd 창에서 yarn upgrade 입력해라. 그러면 해결... 아마도.. 저게 업글 안되면 안되는 듯...

출처: https://money2.daishin.com/e5/mboard/ptype_basic/HTS_Plus_Helper/DW_Basic_Read_Page.aspx?boardseq=284&seq=11&page=13&searchString=&p=8839&v=8642&m=9508 

설명: 각종코드정보및코드리스트를얻을수있습니다.

모듈위치: CpUtil.dll

Method

[주식/선물/옵션]

value = object.CodeToName( code )

code 에해당하는주식/선물/옵션종목명을반환한다.

code : 주식/선물/옵션코드

반환값 : 주식/선물/옵션종목명

[주식코드정보]

value = object.GetStockMarginRate( code )

code 에해당하는주식매수증거금율을반환한다.

code : 주식코드
반환값 : 주식매수증거금율

value = object.GetStockMemeMin( code )

code 에해당하는주식매매거래단위주식수를반환한다.

code : 주식코드
반환값 : 주식매매거래단위주식수

value = object.GetStockIndustryCode ( code )

code 에해당하는증권전산업종코드를반환한다.

code : 주식코드
반환값 : 증권전산업종코드

value = object.GetStockMarketKind ( code )

code 에해당하는소속부를반환한다.

code : 주식코드
반환값 : 소속부
typedefenum{
[helpstring("구분없음")]CPC_MARKET_NULL= 0,
[helpstring("거래소")]   CPC_MARKET_KOSPI= 1,
[helpstring("코스닥")]   CPC_MARKET_KOSDAQ= 2,
[helpstring("K-OTC")] CPC_MARKET_FREEBOARD= 3,
[helpstring("KRX")]       CPC_MARKET_KRX= 4,
[helpstring("KONEX")] CPC_MARKET_KONEX= 5,
}CPE_MARKET_KIND;

value = object.GetStockControlKind ( code )

code 에해당하는감리구분반환한다.

code : 주식코드
반환값 : 감리구분
typedefenum {
[helpstring("정상")]   CPC_CONTROL_NONE   = 0,
[helpstring("주의")]   CPC_CONTROL_ATTENTION= 1,
[helpstring("경고")]   CPC_CONTROL_WARNING= 2,
[helpstring("위험예고")]CPC_CONTROL_DANGER_NOTICE= 3,
[helpstring("위험")]   CPC_CONTROL_DANGER= 4,
[helpstring("경고예고")]   CPC_CONTROL_WARNING_NOTICE= 5,
}CPE_CONTROL_KIND;

value = object.GetOverHeating ( code )

code 에 해당하는 단기과열 구분 반환한다.

code : 주식코드
반환값 : 단기과열 구분
typedefenum {
[helpstring("해당 없음")]   CPC_OVERHEATL_NULL   = 0,
[helpstring("지정예고")]   CPC_OVERHEAT_NOTICE= 1,
[helpstring("지정")]   CPC_OVERHEAT= 2,
[helpstring("해제연기/연장")]CPC_OVERHEAT_EXT= 3,
}CPE_ECT_OVERHEAT;

value = object.IsStockArrgSby( code )

code에 해당하는 정리매매 종목여부를 반환한다

code : 주식코드
반환값 : 정리매매 종목 여부 (BOOL)

value = object.IsStockIoi( code )

code에 해당하는 ETN/ETF 투자유의 종목여부를 반환한다

code : ETN/ETF 주식코드
반환값 : 투자유의 종목 여부 (BOOL)

value = object.GetStockSupervisionKind ( code )

code 에해당하는관리구분반환한다.

code : 주식코드
반환값 : 관리구분
typedefenum   {
[helpstring("일반종목")]CPC_SUPERVISION_NONE= 0,
[helpstring("관리")]   CPC_SUPERVISION_NORMAL= 1,
}CPE_SUPERVISION_KIND;

value = object.GetStockStatusKind ( code )

code 에해당하는주식상태를반환한다

code : 주식코드
반환값 : 관리구분
typedefenum   {
[helpstring("정상")]   CPC_STOCK_STATUS_NORMAL= 0,
[helpstring("거래정지")]CPC_STOCK_STATUS_STOP= 1,
[helpstring("거래중단")]CPC_STOCK_STATUS_BREAK= 2,
}CPE_SUPERVISION_KIND;

value = object.GetStockCapital ( code )

code 에해당하는자본금규모구분반환한다.

code : 주식코드
반환값 : 자본금규모구분
typedefenum {
[helpstring("제외")]   CPC_CAPITAL_NULL  = 0,
[helpstring("대")]   CPC_CAPITAL_LARGE  = 1,
[helpstring("중")]   CPC_CAPITAL_MIDDLE  = 2,
[helpstring("소")]   CPC_CAPITAL_SMALL  = 3
}CPE_CAPITAL_SIZE;

value = object.GetStockFiscalMonth ( code )

code 에해당하는결산기반환한다.

code : 주식코드
반환값 : 결산기

value = object.GetStockGroupCode ( code )

code 에해당하는그룹(계열사)코드반환한다.

code : 주식코드
반환값 : 그룹(계열사)코드

value = object.GetStockKospi200Kind ( code )

code 에해당하는KOSPI200 종목여부반환한다.

code : 주식코드
반환값 : KOSPI200 종목여부
typedefenum {
[helpstring("미채용")]      CPC_KOSPI200_NONE  = 0,
[helpstring("제조업")]      CPC_KOSPI200_MANUFACTURE= 1,
[helpstring("전기통신업")]   CPC_KOSPI200_TELECOMMUNICATION= 2,
[helpstring("건설업")]      CPC_KOSPI200_CONSTRUCT= 3,
[helpstring("유통업")]      CPC_KOSPI200_CURRENCY= 4,
[helpstring("금융업")]      CPC_KOSPI200_FINANCE= 5,
}CPE_KOSPI200_KIND;

2011년 4월 1일부터아래값으로변경

 [helpstring("미채용")]          CPC_KOSPI200_NONE    = 0, 
 [helpstring("건설")]             CPC_KOSPI200_MANUFACTURE  = 1, 
 [helpstring("중공업")]          CPC_KOSPI200_SHIP    = 2,
  [helpstring("철강소재")]      CPC_KOSPI200_IRON    = 3,
  [helpstring("에너지화학")]   CPC_KOSPI200_ENERGY    = 4,
  [helpstring("정보통신")]      CPC_KOSPI200_INFO    = 5,  
  [helpstring("금융")]            CPC_KOSPI200_FINANCE   = 6,
  [helpstring("필수소비재")]   CPC_KOSPI200_NEC_CONS   = 7,
  [helpstring("자유소비재")]   CPC_KOSPI200_FREE_CONS   = 8,
  [helpstring("산업재")]         CPC_KOSPI200_INDUSTRY_CONS  = 9,
  [helpstring("건강관리")]      CPC_KOSPI200_HEALTHCARE   = 10,
  [helpstring("커뮤니케이션")]CPC_KOSPI200_COMMUNICATION  = 11,

value = object.GetStockSectionKind( code )

code 에해당하는부구분코드를반환한다

code : 주식코드

반환값 : 부구분코드

typedefenum

{

  [helpstring("구분없음")]   CPC_KSE_SECTION_KIND_NULL= 0,

   [helpstring("주권")]   CPC_KSE_SECTION_KIND_ST   = 1,

   [helpstring("투자회사")]   CPC_KSE_SECTION_KIND_MF    = 2,

  [helpstring("부동산투자회사"]   CPC_KSE_SECTION_KIND_RT    = 3,

  [helpstring("선박투자회사")]   CPC_KSE_SECTION_KIND_SC    = 4,

  [helpstring("사회간접자본투융자회사")]CPC_KSE_SECTION_KIND_IF = 5,

  [helpstring("주식예탁증서")]   CPC_KSE_SECTION_KIND_DR    = 6,

  [helpstring("신수인수권증권")]   CPC_KSE_SECTION_KIND_SW    = 7,

  [helpstring("신주인수권증서")]   CPC_KSE_SECTION_KIND_SR    = 8,

  [helpstring("주식워런트증권")]   CPC_KSE_SECTION_KIND_ELW = 9,

  [helpstring("상장지수펀드(ETF)")]CPC_KSE_SECTION_KIND_ETF = 10,

  [helpstring("수익증권")]    CPC_KSE_SECTION_KIND_BC    = 11,

  [helpstring("해외ETF")]      CPC_KSE_SECTION_KIND_FETF   = 12,

  [helpstring("외국주권")]    CPC_KSE_SECTION_KIND_FOREIGN = 13,

  [helpstring("선물")]      CPC_KSE_SECTION_KIND_FU    = 14,

  [helpstring("옵션")]      CPC_KSE_SECTION_KIND_OP    = 15,    

  [helpstring("KONEX")]      CPC_KSE_SECTION_KIND_KN    = 16,

  [helpstring("ETN")]      CPC_KSE_SECTION_KIND_ETN     = 17,  

} CPE_KSE_SECTION_KIND;

value = object.GetStockLacKind ( code )

code 에해당하는락구분코드를반환한다

code : 주식코드

반환값 : 락구분코드

typedefenum

 {

  [helpstring("구분없음")] CPC_LAC_NORMAL= 0,

  [helpstring("권리락")] CPC_LAC_EX_RIGHTS   = 1,

  [helpstring("배당락")]   CPC_LAC_EX_DIVIDEND= 2,

  [helpstring("분배락")]   CPC_LAC_EX_DISTRI_DIVIDEND   = 3,

  [helpstring("권배락")]   CPC_LAC_EX_RIGHTS_DIVIDEND   = 4,

  [helpstring("중간배당락")]CPC_LAC_INTERIM_DIVIDEND   = 5,

  [helpstring("권리중간배당락")]CPC_LAC_EX_RIGHTS_INTERIM_DIVIDEND= 6,

  [helpstring("기타")]   CPC_LAC_ETC   = 99,

 } CPE_LAC_KIND;

value = object.GetStockListedDate ( code )

code 에해당하는상장일을반환한다

code : 주식코드
반환값 : 상장일 (LONG)

value = object.GetStockMaxPrice ( code )

code 에해당하는상한가를반환한다

code : 주식코드
반환값 : 상한가(LONG)

value = object.GetStockMinPrice ( code )

code 에해당하는하한가를반환한다

code : 주식코드
반환값 : 하한가(LONG)

value = object.GetStockParPrice ( code )

code 에해당하는액면가를반환한다

code : 주식코드
반환값 : 액면가(LONG)

value = object.GetStockStdPrice ( code )

code 에해당하는권리락등으로인한기준가를반환한다

code : 주식코드
반환값 : 기준가(LONG)

value = object.GetStockYdOpenPrice ( code )

code 에해당하는전일시가를반환한다

code : 주식코드
반환값 : 전일시가(LONG)

value = object.GetStockYdHighPrice ( code )

code 에해당하는전일고가를반환한다

code : 주식코드
반환값 : 전일고가(LONG)

value = object.GetStockYdLowPrice ( code )

code 에해당하는전일저가를반환한다

code : 주식코드
반환값 : 전일저가(LONG)

value = object.GetStockYdClosePrice ( code )

code 에해당하는전일종가를반환한다

code : 주식코드
반환값 : 전일종가(LONG)

value = object.IsStockCreditEnable( code )

code 에해당하는신용가능종목여부를반환한다

code : 주식코드
반환값 : 신용여부 (BOOL)

value = object.GetStockParPriceChageType ( code )

code 에해당하는액면정보코드를반환한다

code : 주식코드

반환값 : 액면정보코드

typedefenum

   {

   [helpstring("해당없음")]   CPC_PARPRICE_CHANGE_NONE   = 0,

 [helpstring("액면분할")]   CPC_PARPRICE_CHANGE_DIVIDE   = 1,   

 [helpstring("액면병합")]   CPC_PARPRICE_CHANGE_MERGE   = 2,   

 [helpstring("기타")]   CPC_PARPRICE_CHANGE_ETC = 99,

 }CPE_ECT_PARPRICE_CHANGE; 

value = object.IsSPAC( code )

code에 해당하는 SPAC 종목여부를 반환한다

code : 주식코드
반환값 : SPAC 여부 (BOOL)

value = object.GetMiniFutureList()

미니KOSPI200 선물에 해당하는 종목배열을 반환한다

반환값 : 미니KOSPI 선물 종목리스트(배열)

VB ex)

Dim CodeMgrAs New CpCodeMgr

Dim codes As Variant

codes = CodeMgr. GetMiniFutureList ()

For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

Next

value = object.GetMiniOptionList()

미니KOSPI200 옵션에 해당하는 종목배열을 반환한다

반환값 : 미니KOSPI 옵션 종목리스트(배열)

VB ex)

Dim CodeMgrAs New CpCodeMgr

Dim codes As Variant

codes = CodeMgr.GetMiniOptionList ()

For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

Next 

value = object.ReLoadPortData()

CYBOS5 관심종목(700 ~799 ) 데이터를 다시 가져오기 위해 호출한다. 

value = object.IsBigListingStock( code )

code 에 해당하는 상장주식수 20억 이상여부를 반환한다

code : 주식코드

[Basket 정보]
아래두함수는 CpElwCode에도동일한함수명으로존재합니다.

기존사용고객님을위해서CpElwCode/CpCodeMgr 2군데서제공합니다.

value = object.GetStockElwBasketCodeList( code )

Elw 기초자산코드리스트얻기 (바스켓)

반환값 : 입력한코드에해당하는바스켓코드리스트(배열)

value = object.GetStockElwBasketCompList( code )

Elw 기초자산비율리스트얻기 (바스켓)

반환값 : 입력한코드에해당하는바스켓비율리스트(배열)

[각종코드리스트]

value = object.GetStockListByMarket(CPE_MARKET_KIND code )

시장구분에따른주식종목배열을반환하다

반환값: 입력한시장구분(CPE_MARKET_KIND)에해당하는종목리스트(배열)

VB ex)

Dim WorkKey As New CpTdUtil

Dim codes As Variant

   codes = CodeMgr.GetStockListByMarket(CPC_MARKET_KOSPI) ' 거래소

For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

  Debug.Print CodeMgr. CodeToName(codes(i))

Next

VC++ ex)

ICpCodeMgrPtr codeMgr;

codeMgr.createInstance(_uuidof(CpCodeMgr));

variant_t vArray, vItem;

CComSafeArray<VARIANT> sa;

vArray = codeMgr->GetIndustryList();

sa.Attach(vArray.Detach().parray);

for (LONG nlb = sa.GetLowerBound(), nub = sa.GetUpperBound(); nlb <= nub; nlb++)

{
  vItem = sa.GetAt(nlb);
  _tprintf(_T("%s\n"), (LPCTSTR)(bstr_t)vItem);

}

value = object.GetGroupCodeList( code )

관심종목(700 ~799 ) 및업종코드(GetIndustryList 참고)에해당하는종목배열을반환한다

반환값 : 입력한그룹에해당하는종목리스트(배열)

VB ex)

Dim CodeMgrAs New CpCodeMgr

Dim codes As Variant

   codes = CodeMgr. GetGroupCodeList (24) ' 24 증권업

For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

Next

value = object.GetGroupName ( code )

관심종목(700 ~799 ) 및업종코드에해당하는명칭을반환한다

반환값 : 관심종목명및업종코드명

object.GetIndustryList ()

증권전산업종코드리스트를반환한다.

반환값 : 증권전산업종코드(배열)

VB ex)

Dim CodeMgrAs New CpCodeMgr

Dim codes As Variant

   codes = CodeMgr.GetIndustryList ()

   For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

Next

value = object.GetIndustryName ( code )

증권전산업종코드에해당하는증권전산업종명을반환한다

반환값 : 증권전산업종명

object.GetMemberList ( )

거래원코드(회원사)의코드리스트를반환한다.

반환값 : 거래원코드코드(배열)

value = object.GetMemberName ( code )

거래원코드(회원사)코드에해당하는거래원코드명을반환한다

반환값 : 거래원코드명

object.GetKosdaqIndustry1List ()

코스닥산업별코드리스트를반환한다.

반환값 : 코스닥산업별코드(배열)

object.GetKosdaqIndustry2List ()

코스닥지수업종코드리스트를반환한다.

반환값 : 코스닥지수별코드(배열)

VB ex)

Dim CodeMgrAs New CpCodeMgr

Dim codes As Variant

   codes = CodeMgr. GetKosdaqIndustry2List ()

   For i = LBound(codes) To UBound(codes)

  Debug.Print codes(i)

Next

[기타정보]

value = object. GetMarketStartTime ()

장시작시각얻기 (ex 9시일 경우 리턴값 900)

반환값 :장시작시각

value = object. GetMarketEndTime ()

장마감시각얻기 (ex오후 3시30분 일경우 리턴값 1530,수능일 1630)

반환값 : 장마감시각

value = object. IsFrnMember(code)

code에 해당하는 외국계 회원사 여부를 반환함.

code : 회원사 코드

[해외선물]

value = object. GetTickUnit (code )

해외선물  종목 code의  최소변동 호가단위

반환값 : 최소변동 호가단위

value = object. GetTickValue (code )

해외선물  종목 code의   1계약당 최소가격 변동폭

반환값 :   1계약당 최소가격 변동폭

object.OvFutGetAllCodeList( )

해외선물 전체 코드 리스트를 반환한다.

반환값 : 해외선물 코드(배열)

object.OvFutGetExchList( )

해외선물 거래소 리스트를 반환한다.

반환값 : 해외선물 거래소 코드(배열)

value = object.OvFutCodeToName(code)

해외선물  종목 code의  종목명을 반환한다

반환값 : 해외선물 종목명

value = object.OvFutGetExchCode(code)

해외선물  종목 code의  거래소 코드를 반환한다.

반환값 : 거래소 코드

value = object.OvFutGetLastTradeDate(code)

해외선물  종목 code의 최종 거래일을 반환한다.

반환값 : 최종거래일(LONG)

value = object.OvFutGetProdCode(code)

해외선물  종목 code의  품목코드를 반환한다.

반환값 : 품목코드

value = object.GetStartTime(code)

해외선물  종목 code의 시작 시간(현지시각)을 반환한다.

반환값 :현지시각(LONG)

value = object.GetEndTime(code)

해외선물  종목 code의 종료 시간(현지시각)을 반환한다.

반환값 : 현지시각(LONG)

value = object.IsTradeCondition(code)

해외선물  종목 code의 거래가능여부를 반환한다.

반환값 : 거래가능여부 (BOOL)

[주식선물]

object.GetStockFutureList( )

주식선물 전체 코드 리스트를 반환한다.

반환값 : 주식선물 코드(배열)

object.GetStockFutureBaseList( )

주식선물 기초자산 리스트를 반환한다.

반환값 : 기초자산 코드(배열)

value = object.GetStockFutureListByBaseCode(code)

기초자산 code의  주식선물 코드 리스트를 반환한다

반환값 : 주식선물 코드(배열)

value = object.GetStockFutureBaseCode(code)

주식선물  종목 code의  기초자산 코드를 반환한다.

반환값 : 기초자산 코드

https://www.itworld.co.kr/news/215374

https://www.hankyung.com/it/article/202107060891i

https://post.naver.com/viewer/postView.nhn?volumeNo=28461198&memberNo=39087579 

이거 분명 제약조건 날리고 해도 안될때 있음.

그럴땐 

Unique Index에 관련 설정 날리고 해봐라.

그래도 안되면 테이블 시원하게 날리고 재생성해라.