2번째인생

 mysql subquery 사용시 서브퀴리안에 where 절에 서버 퀴리를 사용 하는 경우 속도 저하가 있다 where 절의 서버퀴리를 조인으로 처리 하여 받아서 메인절에 처리 하면 된다. select             (SELECT -- (select ----) ) AAAAA from tb_ _--> 변경후 select           (SELECT -- (tb_b) ) AAAAA from tb_a, tb_b

 Caused by: com.android.tools.r8.utils.b: Type androidx.activity.R$drawable is defined multiple times: flutter clean 에서 발생 이파일을 지우고 다시 동작 시켜 보았다

  /* 날짜를 받아서 몇번째 주인지 표시 하는 것 */ static String WeekCountHangul (DateTime cday) { var weekCount = cday. weekOfYear -cday.add( Duration (days: 1 -cday. day )). weekOfYear + 1 ; String weekCountHangul = "" ; switch (weekCount) { case 1 : weekCountHangul = " 첫째주 " ; break; case 2 : weekCountHangul = " 둘째주 " ; break; case 3 : weekCountHangul = " 세째주 " ; break; case 4 : weekCountHangul = " 네째주 " ; break; case 5 : weekCountHangul = " 다섯째주 " ; break; case 6 : weekCountHangul = " 여섯째주 " ; break; } return weekCountHangul ; } week_of_year : ^2.0.0 import 'package:week_of_year/week_of_year.dart' ;

  GestureDetector ( onVerticalDragEnd: (details) { setState(() { // viewWeek = details.velocity.pixelsPerSecond.dy < 0 // ? false // : true; print( "ssss===" +details. primaryVelocity .toString()) ; if (details. primaryVelocity < 0 ) { // 주 단위 보여 주기 viewWeek = true; viewCalender = false; titelCalenderYn = false; } else { viewWeek = false; viewCalender = true; titelCalenderYn = true; } }) ; } , child: Column ( children: [ Visibility ( visible: viewCalender , child: Container ( height: calSize , margin: EdgeInsets . fromLTRB ( 16 , 0 , 16 , 0 ) , padding: EdgeInsets . fromLTRB ( 0 , 0 , 0 , 0 ) , // 6 열인 경우 504 5 열인경우 420 alignment: Alignment. center , child: _salesCalenderList(salesDetailListCalender) , ) , ) , Visibility ( visible: viewWe...

  GestureDetector ( onTap: () { setState(() { detailViewYn =!detailViewYn ; _changed(detailViewYn) ; }) ; } , child: SvgPicture . asset ( ' ${iconNm} ' , width: 9 , height: 13 , color: Colors. black , ) , ) ,

  ListView padding setting을 안하는 경우 자동으로 설정 되므로 이를 수정 해야 한다. child: Container ( color: Color ( 0xffFFFFFF ) , child: ListView ( // padding: EdgeInsets.fromLTRB(0, 4, 0, 18), scrollDirection: Axis. vertical , shrinkWrap: true, children: <Widget>[ Container ( padding: EdgeInsets . fromLTRB ( 16 , 0 , 16 , 0 ) , child: Column ( children: <Widget>[ Container ( height: 66 , child: DottedBorder ( dashPattern: [ 2 , 2 ] , strokeWidth: 1 , borderType: BorderType. RRect , radius: Radius . circular ( 8 ) , color: Color ( 0xffDDDDDD ) , child: Row ( mainAxisAlignment: MainAxisAlignment. spaceBetween , crossAxisAlignment: CrossAxisAlignment. center , children: <Widget>[

  leftTitles: SideTitles ( showTitles: true, getTextStyles: (value) => const TextStyle ( color: Color ( 0xff7589a2 ) , fontWeight: FontWeight. bold , fontSize: 14 ) , margin: 10 , interval: 500 ) ,