[[$tplFiles]]
[[$tpl_spSaldo]]
[[$tplSpCardDueDate]]
[[$jsInvoiceLesson]]

[[!runHook?hook=`chunk/contacts`]]
[[!runHook?hook=`chunk/ecard`]]

<script id="tplSpCardRazr" type="x-jsrender">
<div class="d-flex align-items-center">
	<button type="button" class="btn-link w-auto mr-2 spClick" data-spdshow="razrdate"
		data-link="{VisibleIf value && value!='-'} {:value}"></button>
	<button type="button" class="btn btn-xs btn-secondary spClick" data-spdtype="razrdate">{{fmtIco:'fa-plus'}}</button>
</div>
</script>

<script id="tplSpCardTrainer" type="x-jsrender">
	<button type="button" class="btn-link"
		data-link="{formatEmpty:~edata[text||'trainer_name']} {on ~S.changeSpCardData ~edata name}"></button>
</script>

<script id="tplSpCardMoneyMenu" type="text/x-jsrender">
<div class="dropdown">
    <button type="button" class="btn btn-sm btn-secondary" data-toggle="dropdown">{{fmtIco:'fa-ellipsis-h'}}</button>
    <div class="dropdown-menu dropdown1-menu-right spCardMoneyMenu">
        <div class="dropdown-arrow"></div>
        <button type="button" class="dropdown-item" data-run="/chunk/sp.printrevise" data-link="~i18n.idSportsmen.revise"></button>
        <div class="dropdown-divider"></div>
        <button type="button" class="dropdown-item" data-link="{on ~recoverInvoice} {:~i18n.main.recalc}"></button>
        <div data-link="{menuRows ~mnu}"></div>
    </div>
</div>
</script>


<script id="tpl_sportsmenCard" type="x-jsrender">
<div data-link="{VisibleIf sp^key && !sp^id} html{:~S.noData()}"></div>
<div data-link="{VisibleIf ~setSCRMsp(sp)} {on 'setROW.idSportsmen' ~eCardSpEdit} {on 'click' '.spClick' ~spClick}">
    <h3 class="section-title py-0 d-flex scrmcard-title">
        <span data-link="{:sp^name} data-id{:sp^id}" data-field="idSportsmen:name" data-roinplace="fieldEDIT" class="mt-1"></span>
        <span class="dropdown ml-2">
            <button type="button" class="btn btn-sm btn-icon btn-light" data-toggle="dropdown"
            	data-link="{SpinIf loading}">
                <i class="fa fa-fw fa-ellipsis-v" data-link="visible{:!loading}"></i>
            </button>
            <div class="dropdown-menu">
                <div class="dropdown-arrow"></div>
                <a href="#" target="_blank" class="dropdown-item"
                    data-link="href{:~S.spHref(key)} {:~i18n.main.cabinet}"></a>
                <a href="#" target="_blank" class="dropdown-item"
                    data-link="href{:~S.qrHref(key)} {on ~spVisit sp} {:~i18n.idSportsmen.addVisit}"></a>
				<button type="button" class="dropdown-item" data-link="{on ~newTask} {:~i18n.main.task}"></button>
				<a href="#" target="_blank" class="dropdown-item"
					data-link="href{formatLinkedLead:sp^id} {:~i18n.idSportsmen.linkedLead} {VisibleIf !~S.empty(sp^cnt_lead)}"></a>

                [[-{^{for ~S._mnu^spCard ~sp=sp^ tmpl='#tplMenuItem' /}}]]
                {^{menuRows ~Menu.spCard ~sp=sp^ /}}
                
                <div class="d-flex small px-2 pt-2 border-top">
                    <a href="#" class="d-block text-muted" data-run="/chunk/sp.sysinfo">id <u data-link="sp^id"></u></a>
                    <a href="#" class="d-block text-muted ml-auto fmtCreated stop-propagation"
                        data-link="data-id{:sp^id} text{formatDate:sp^created}" data-tbl="idSportsmen"></a>
                </div>
            </div>
        </span>
    </h3>
    <div class="d-flex">
        <button type="button" class="btn btn-subtle-primary btn-xs"
            data-link="html{:sp^status} {on ~S.changeSpCardData sp 'status'} class{merge:spArc toggle='btn-subtle-dark'} title{:~i18n.main.status}"></button>
        <button type="button" class="btn btn-subtle-light btn-xs ml-2 pauseFocus" id="spCardSaldo"
            data-link="{on ~addInvoice true} {include sp tmpl='SpSaldo'}"></button>
        <button type="button" class="btn btn-xs btn-subtle-secondary" data-run="/chunk/invoice.lesson"
            data-link="html{:~spDuedate(sp)}"></button>
    </div>

    <div class="nav-scroller border-bottom">
        <nav class="nav nav-tabs sptabs" role="tablist" data-link="{for ~Menu.spTabs ~sp=sp tmpl='navTab'} {on 'SCRMtabShow' showSpTab}">
            [[- data-link="{on 'calculate' '[data-toggle=tab]' ~tabCalculate}"]]
        </nav>
    </div>
    <div class="tab-content mt-2" id="spCardTabs" style="min-height:420px;">

        <!-- INFO -->
        <div class="tab-pane active" id="t_spInfo">

<div class="row">
    <div class="col-md-6">
		<div class="row">
            <div class="col-lg-4 spFiles" data-file1type="photo"
                data-link="{on 'scrmFiles.'+sp^key ~S.linkFile 'FilesPhoto1'}">
            </div>
            <div class="col-lg-8">
                <div class="card card-body mb-2">
                    <div class="d-flex align-items-start">
                        <a href="#" target="_blank" data-link="href{:~S.spHref(key)}" class="ml-n1 flex-grow-1 d-flex mr-2 overflow-hidden">
                            <div class="mr-1 flex-shrink-0" data-link="html{fmtIco:'fa-external-link-square'}"></div>
                            <div class="text-truncate" style="min-width: 0;">
                                <span data-link="{:sp^user_email || ~i18n.main.cabinet}"></span>
                                <div data-link="visible{:sp^user_email!=sp^user_name} {:sp^user_name}" class="text-muted small"></div>    
                            </div>
                        </a>
                        <div class="my-n2 mr-n2 flex-shrink-0">
                            {^{if !sp^user_name}}
                            <button type="button" class="btn btn-icon btn-light" data-link="{on ~idUserAdd sp} html{fmtIco:'fa-key'}"></button>
                            {{else}}
                            <div class="dropdown">
                                <button type="button" data-toggle="dropdown"
                                    data-link="class{:'btn btn-icon btn-subtle-'+ (~S.empty(sp^user_active)? 'danger':'success')} html{fmtIco:'fa-key'}">
                                    </button>
                                <div class="dropdown-menu dropdown-menu-right">
                                    <div class="dropdown-arrow"></div>
                                    <button type="button" class="dropdown-item"
                                        data-link="{on ~idUser sp} {:~i18n.main.opts}"></button>
                                    <button type="button" class="dropdown-item" data-run="/chunk/user.edit" 
                                        data-link="data-username{:sp^user_email} {:~i18n.login.resetpwd}" data-mode="forgotpassword"></button>
                                    <div class="dropdown-divider"></div>
                                    <button type="button" class="dropdown-item"
                                        data-link="{on ~idUserDisable sp} {:~i18n.login.off}"></button>
                                </div>
                            </div>
                            {{/if}}
                        </div>
                    </div>
                    [[-<div data-link="html{:sp^username} visible{:sp^username}" class="mt-2"></div>]]
                </div>
                
                <div class="eCardSpContact my-3"></div>

            </div>
        </div>
		
        <div class="card card-body pr-2">
            <div class="d-flex justify-content-between">
                <h4 class="scrm-title" data-link="~i18n.main.typeinvoice"></h4>
                <button type="button" class="btn btn-icon btn-light my-n2"
                    data-link="{on ~addSportsmenInvType} html{fmtIco:'fa-plus'}"></button>
            </div>
            <div data-link="{for sp^idSportsmenInvType ~sp=sp tmpl='#tpl_idSportsmenInvType'}"></div>
        </div>
		
        <div class="card card-body pr-2">
            <div class="d-flex justify-content-between">
                <h4 class="scrm-title" data-link="~i18n.main.clubsquad"></h4>
                <button type="button" class="btn btn-icon btn-light my-n2" data-run="/chunk/squadlist"
                    data-link="{VisibleIf !spArc} {on 'squadSelected' ~squadSelected} data-ismain{:SportsmenSquadIsMain || 0} html{fmtIco:'fa-plus'}">
                </button>
            </div>
            <div data-link="{include tmpl='SpSquadBlock' ~sqMenu=true}"></div>
        </div>

        <div class="card card-body eCardSpManagerTr"></div>

        <div class="card card-body pr-2" data-link="{ContactBlock sp^idContacts tbl='idSportsmen' tblItem=sp }">
        </div>
        
    </div>
    <div class="col-md-6">
        <div class="card card-body eCard_spManager">
            
        </div>

        [[-<table class="table table-sm table-striped1">
            <tbody id="infotable">
            {^{for infoTable}}
            <tr class="crd_{{:name}}"><th>{{:label||name}}</th><td class="{{:CLS}}">{{:HTML}}</td></tr>
            {{/for}}
            </tbody>
        </table>]]

        <div id="sportsmenFiles" class="spFiles"
            data-link="{on 'scrmFiles.'+sp^key ~S.linkFile ''}"></div>
    </div>
</div>

        </div><!-- end.INFO -->
        
        <div id="t_spTask" class="tab-pane gridBlock">
        	<div class="mb-2">
                <button type="button" class="btn btn-success btn-sm" data-link="{on ~newTask}">{{fmtIco:'fa-plus'}}</button>
                <button type="button" class="btn btn-sm btn-secondary" data-fltrgrid="#spTask{{:_id}}">{{fmtIco:'fa-filter'}}</button>
            </div>
        </div>

        <div id="t_spInvoice" class="tab-pane gridBlock">
            <div class="d-flex justify1-content-between mb-2" id="spInvoiceActionBar">
                <div class="btn-group mr-1" data-link="visible{:~S.can('Invoice', 'add')}">
                    <button type="button" class="btn btn-sm btn-success btn-addinvoice" data-link="{on ~addInvoice false} html{fmtIco:'fa-plus'}"></button>
                    <button type="button" class="btn btn-sm btn-success" data-link="html{fmtIco:'fa-calculator'}" data-run="/chunk/invoice.schedule"></button>
                </div>
                <button type="button" class="btn btn-primary btn-sm mr-1"
                    data-link="{on ~repeatInvoice} visible{:~S.can('Invoice', 'add') && selInvoice}">{{fmtIco:'fa-repeat'}}</button>
                <button type="button" class="btn btn-secondary btn-sm mr-1" data-link="{on ~linkPay} visible{:(selInvoice && memPay)} html{fmtIco:'fa-chain'}"></button>
                <button type="button" class="btn btn-secondary btn-sm showGridFilter mr-1">{{fmtIco:'fa-filter'}}</button>
                {{include ~mnu=~Menu.spCardPay tmpl="SpCardMoneyMenu" /}}
            </div>
            <table id="grinvoice" data-entity="idInvoice" class="calculateGrid"></table>
        </div>
        <div id="t_spPays" class="tab-pane gridBlock">
            <div class="d-flex justify1-content-between mb-2" id="spPayActionBar">
                <button type="button" class="btn btn-success btn-sm btn-addpay mr-1"
                    data-link="{on ~addInvoice true} visible{:~S.can('Pay', 'add')} html{fmtIco:'fa-plus'}"></button>
                <button type="button" class="btn btn-secondary btn-sm mr-1"
                    data-link="{on ~cutPay} visible{:(~S.can('Pay', 'del') && selPay)} html{fmtIco:'fa-copy'}"></button>
                <button type="button" class="btn btn-secondary btn-sm mr-1"
                    data-link="visible{:memPay} {on ~pastePay} html{fmtIco:'fa-paste'}"></button>
                <button type="button" class="btn btn-secondary btn-sm showGridFilter mr-1">{{fmtIco:'fa-filter'}}</button>
                {{include ~mnu=~Menu.spCardInvoice tmpl="SpCardMoneyMenu" /}}
            </div>
            <table id="grpays" data-entity="idPay" class="calculateGrid"></table>
        </div>
        <div id="t_spLessons" class="tab-pane gridBlock">
            <div class="d-flex">
                <a href="#" target="_blank" class="btn btn-success btn-sm mb-2" id="addSpVisit"
                    data-link="href{:~S.qrHref(key)} {on ~spVisit sp} html{fmtIco:'fa-plus'}"></a>
                <button type="button" class="btn btn-secondary btn-sm ml-1 showGridFilter">{{fmtIco:'fa-filter'}}</button>
            </div>
            <table id="spLessons" data-entity="idLesson" class="calculateGrid"></table>
        </div>
        <div id="t_spEvents" class="tab-pane">
            <div class="mb-2">
                <button type="button" class="btn btn-success btn-sm" data-run="/chunk/gotoevent">{{fmtIco:'fa-plus'}}</button>
                <button type="button" class="btn btn-sm btn-secondary" data-fltrgrid="#spEvent{{:_id}}">{{fmtIco:'fa-filter'}}</button>
            </div>
            <div class="row">
                <div class="col-md-6">
                    <table id="spEvent{{:_id}}" data-entity="idEvent" class="calculateGrid"></table>
                </div>
                <div class="col-md-6" data-link="visible{:selEventID}">
                	<h3 class="section-title my-2 d-block d-md-none" data-link="objName:selSpEvent"></h3>
                    <table id="spEventSportsmen" data-entity="idEventMember"></table>
                </div>
            </div>
        </div>
        <div id="t_spChanges" class="tab-pane gridBlock">
            <table id="grchanges" data-entity="idChanges" class="calculateGrid"></table>
        </div>
        
        <div id="t_spDate" class="tab-pane gridBlock">
			<div class="d-flex mb-2">
				<div data-link="{DDmenu btnCls='btn-sm btn-success' ico='fa-plus' dir='left'}">
					{^{for spDates ~spID=sp.id}}
				    <div role="button" class="dropdown-item spClick" data-spdtype="{{:alias}}">
				        {{:name}}
				        {{if status}}<b class="text-{{:status}} ml-1">{{fmtIco:'fa-exclamation-circle'}}</b>{{/if}}
				    </div>
					{{/for}}
			    </div>
                <button type="button" class="btn btn-sm btn-subtle-dark ml-2 showGridFilter">{{fmtIco:'fa-filter'}}</button>
            </div>
            <table id="grspdate" data-entity="idSportsmenDate" class="calculateGrid"></table>
        </div>

        
        {^{for ~Menu.spTabs filter=~fltrTab ~SP=#data}}
            <div class="tab-pane" id="{{:id}}" data-link="{include tmpl=tpl||''}"></div>
        {{/for}}
    </div>
</div>
</script>

[[$squadBlock]]

<script id="tpl_idSportsmenInvType" type="text/x-jsrender">
    <div class="d-flex" data-link="class{merge:true toggle=((#index!=0)? 'border-top pt-1 mt-1':'mt-3')}">
        <div class="flex-grow-1">
            <div>{{:typeinvoice_name}}</div>
            <div class="text-muted">{{:stype_name}}</div>
        </div>
		<a href="#" class="mt-1 mr-2 prevent-default" data-link="{on ~editSportsmenInvType}">
            {{if linked!=1}}
                <i class="fa fa-chain-broken" style="font-size:.8em"></i>
            {{/if}}
            {{:~S.format0Money(price)}}
		</a>
        <div data-link="{DDmenu}" class="mt-n1">
            <button type="button" class="dropdown-item"
                data-link="{on ~deleteSportsmenInvType} html{fmtStatus: ico='fa-trash' dd=true label=~i18n.main.del}">
            </button>
            <a href="#" class="d-block small text-muted text-right px-2 pt-2 mt-2 border-top fmtCreated stop-propagation"
                data-id="{{:id}}" data-tbl="idSportsmenInvType">
                {{fmtIco:'fa-clock-o' mr=true}}<span>{{formatDate:created}}</span>
            </a>
        </div>
    </div>
</script>




<script>
SCRM.i18n.set( [[!i18n?cls=`idSportsmen,idEvent,login`]] );
window.clubSpCard = {
    sp: {},
    get: function(field) {
        return SCRM.obj(clubSpCard.sp)[field||'id'];
    },
    eqID: function(params) {
    	var id = SCRM.obj(params).id;
        return id && id == SCRM.obj(clubSpCard.sp).id;
    },
    _id: SCRM.uniqid(),
    titleMenu: [ ],
    pnlSp: $('<div class="spinner-parent DEparent"></div>').appendTo('body'),
    allow: SCRM.app.allow,
    loading: true,
    setLoading: function(L) {
        var tabInfo = $('#t_spInfo', clubSpCard.pnlSp);
        SCRM.link(clubSpCard, 'loading', L);
        spinnr(L, tabInfo);
    },
    TaskTab: {
		id: 't_spTask',
		spTaskGrid: false,
		ico: 'fa-tasks',
		run: '/chunk/task',
		hidden: true
	},
    selSpEvent: null,
    changeSportsmenSquad: function(data) {
        pEDIT('idSportsmenSquad', data, clubSpCard.refreshData);
    },
    refreshTabs: function(tabs, refreshData) {
    	var SpCarD = this;
        if (tabs) $.each(tabs.split(','), function(i, v) {
        	delete SpCarD.ActiveTabs[ v ];
            //$('[href="'+ v +'"]', clubSpCard.sptabs).addClass('calculate');
        });
        if (refreshData) SpCarD.refreshData();
    },
    refreshData: function() {
        clubSpCard.reloadData(function(data) {
            clubSpCard.pnlSp.trigger('OnRefreshSpData', data);
        });
    },
    reloadData: function(callback) {
    	var SpCarD = this;
        SpCarD.setLoading(true);
        $('form.roinplace-container', SpCarD.pnlSp).trigger('reset'); // Выйти из режима редактора в полях
        
        pJSON('/data/sportsmen', {
            key: SpCarD.key,
            mode: 'card'
        }, function(data) {
            var sp = SCRM.obj(data),
            oldSp = SCRM.obj(SpCarD.sp),
            nd = {
                idSportsmen_arc: sp.opts.idSportsmen_arc,
                sp: sp,
                spArc: sp.spArc
            };
            sp.LoadedFromServer = true;
            // Карточку могут открыть по id (сервер это допускает), а ссылки ЛК/QR/оплаты и /data/cabinet требуют key спортсмена
            if (sp.key) nd.key = sp.key;

            SCRM.setClubStatus(sp.clubStatus);

            $.extend(nd, SCRM.squadSplit(sp.idSportsmenSquad));
            nd.SportsmenSquadIsMain = nd.idSportsmenSquad.length? 0 : 1;
            
            if (oldSp.id != sp.id) {
            	SpCarD.ActiveTabs = {}; // Сбросим все загруженные Вкладки
            }
            
            nd['TaskTab.hidden'] = (SpCarD.ActiveTab == '#t_spTask') ? false : SCRM.empty(sp.TaskCount);
            SCRM.link(SpCarD, nd);
            
            $('.spFiles')
            .trigger('scrmFiles.'+ sp.key, $.extend(sp.files, {
                gender: sp.gender
            }));
            
            SpCarD.reaclcTab(SpCarD.ActiveTab);

            SCRM._run('/chunk/ecard', {
                edata: sp,
                block: $('.eCard_spManager', SpCarD.pnlSp),
                ecard: 'spManager',
                ev: 'setROW.idSportsmen'
            });

            SCRM._run('/chunk/ecard', {
                edata: sp,
                block: $('.eCardSpManagerTr', SpCarD.pnlSp),
                ecard: 'spManagerTr',
                ev: 'setROW.idSportsmen'
            });

            SCRM._run('/chunk/ecard', {
                edata: sp,
                block: SpCarD.eCardSpContact,
                ecard: 'spContact',
                ev: 'setROW.idSportsmen'
            });

            if (callback) callback(SpCarD);
            SpCarD.pnlSp.trigger('OnLoadSpData', SpCarD);
            SpCarD.setLoading(false);
        });
    },
    ActiveTab: '#t_spInfo', ActiveTabs: {},
    reaclcTab: function(tabId) {
    	console.log('reaclcTab', this);
    	var spCarD = this;
    	spCarD.ActiveTab = tabId;
    	if (!spCarD.ActiveTabs[ tabId ]) {
    		$(tabId+' .calculateGrid', spCarD.pnlSp).trigger('reloadGrid'); 
    	}
    	spCarD.ActiveTabs[ tabId ] = true;
    },
    showSpTab: function(e, data, tabId) {
    	this.reaclcTab(tabId);
    	console.log('showSpTab', this, e, tabId, data);
    }
};

SCRM.add_mnu('spCard', clubSpCard.titleMenu); // TODO: Delete
SCRM.add_mnu('spTabs', [
    {id: 't_spInfo', name: 'info', active: true},
    clubSpCard.TaskTab,
    {id: 't_spInvoice', _label: 'main.invoices', hidden: !SCRM.can('Invoice')},
    {id: 't_spPays', _label: 'main.pays', hidden: !SCRM.can('Pay')},
    {id: 't_spLessons', _label: 'main.lessons'},
    {id: 't_spDate', html: '<span data-link="html{:~spDateIco(~sp)}"></span>'},
    {id: 't_spEvents', _label: 'main.events'},
    {id: 't_spChanges', _label: 'idSportsmen.changes'}
]);

//SCRM.setClubStatus([[-!clubStatus?tbl=`idSportsmen,idSchedule,Gender`]]);
SCRM.add_mnu('eCard', [[!eCardFields?name=`spContact,spManager,spManagerTr`]] );

SCRM.tmpls.set({
	SportsmenCardTitle: '<div data-link="text{:spCard^sp.name||~S.emptyStr}"></div>',
    SpCardMoneyMenu: '#tplSpCardMoneyMenu',
    SpCardRazr: '#tplSpCardRazr',
    SpCardTrainer: '#tplSpCardTrainer'
});  

SCRM.changeSpCardData = function(sp, field, e, data) {
	// console.log('changeSpCardData', e, data);
	e.preventDefault();
	
	if (!sp || !field) {
		alert('Empty Field OR Sp');
		return;
	}
	var btn = $(SCRM.obj(data.linkCtx).elem||document);
    var rcd = {
    	mdl_id: 'spStatusMdl',
        info: '',
        row: sp,
        field: field,
        onOK: function(e, md) {
            var nd = {
                id: sp.id,
                change_info: md.info
            };
            nd[field] = md.val;
            pEDIT('idSportsmen', nd, function() {
                delete nd.change_info;
                btn.trigger('setROW.idSportsmen', nd);
            });
            return true;
        }
    };
    SCRM.radioch(rcd);
};

$.views.converters({
    formatLinkedLead: function(id) {
        return '/database/leads.html?filter='+
        SCRM.makeUparam({
            sportsmen: id,
            status: ''
        });
    }
});

$.templates('#tpl_sportsmenCard')
.link(clubSpCard.pnlSp, clubSpCard, {
    spDateIco: function(sp) {
        var status = 0,
        	statusTxt = ['','warning','danger'],
            now = SCRM.str2date('now');
        
        var spDates = $.map(SCRM.clubStatus.idSportsmenDate||[], function(v, i) {
            var row = $.extend({}, v, (sp.spDate||{})[v.alias] ),
                ext = row.extended;
            if (!ext.duedate) return row;
            if (!row.max_duedate) {
                row.status = statusTxt[2];
                status = Math.max(status, 2);
                return row;
            }
            if ('daysdanger' in ext) {
                var dd = SCRM.str2date(row.max_duedate);
                dd.setDate(dd.getDate() + ext.daysdanger);
                if (dd < now) {
                    row.status = statusTxt[2];
                    status = Math.max(status, 2);
                    return row;
                }
            }
            if ('dayswarning' in ext) {
                var dw = SCRM.str2date(row.max_duedate);
                dw.setDate(dw.getDate() + ext.dayswarning);
                if (dw < now ) {
                    row.status = statusTxt[1];
                    status = Math.max(status, 1);
                };
            }
            return row;
        });
        status = statusTxt[status];
        SCRM.link(clubSpCard, {
        	spDates: spDates
        });
        return SCRM.fmtIco(status 
        	? 'fa-calendar-minus-o text-' + status
        	: 'fa-calendar-check-o'
        );
    },
    eCardSpEdit: function(e, data, postData, edata) {
        //console.log("eCardSpEdit", e, data, postData, edata)
        SCRM.link(clubSpCard.sp, edata);
    },
    squadSelected: function(e, data, sqData) {
        pEDIT('idSportsmenSquad', {
            sportsmen: clubSpCard.get(),
            squad: sqData.id,
            ismain: sqData.ismain,
            oper: 'add'
        }, clubSpCard.refreshData);
    },
    mainSquad: function(e, data) {
        pEDIT('idSportsmen', {
            id: data.linkCtx.data.sportsmen,
            squad: data.linkCtx.data.squad,
            ignore_squad: 1
        }, clubSpCard.refreshData);
        /*clubSpCard.changeSportsmenSquad({
            id: data.linkCtx.data.id,
            //oper: 'add', // Добавление архивирует старую главную группу
            //squad: data.linkCtx.data.squad,
            //sportsmen: clubSpCard.sp.id,
            ismain: 1
        });*/
    },
    expelSquad: function(e, data) {
        SCRM.confirm(SCRM.i18n.idSportsmen.expel, function(){
            clubSpCard.changeSportsmenSquad({
                id: data.linkCtx.data.id,
                published: ''
            });
        });
    },
	recoverSquad: function(e, data){
        clubSpCard.changeSportsmenSquad({
            id: data.linkCtx.data.id,
            published: 1
        });
	},
	delArcSquad: function(e, data){
        SCRM.confirm(SCRM.i18n.main.del, function(){
            clubSpCard.changeSportsmenSquad({
                oper: 'del',
                id: data.linkCtx.data.id
            });
        });
	},
	hasWdays: function(hwdValue) {
		var d = this.data,
			hasWD = 'visitwdays' in d;
        //console.log('hasWdays', d, hwdValue)
        if (hasWD) {
			d.wdays = [ ];
			const today = new Date();
	
			// Находим ближайший первый день недели
			const currentDay = today.getDay(); // 0-воскресенье, 1-понедельник и т.д.
			let daysToSubtract = (currentDay - SCRM.i18n.firstDayOfWeek + 7) % 7;
			
			const firstWeekdayDate = new Date(today);
			firstWeekdayDate.setDate(today.getDate() - daysToSubtract);
			
			// Заполняем массив днями недели
			for (let i = 0; i < 7; i++) {
				const date = new Date(firstWeekdayDate);
				date.setDate(firstWeekdayDate.getDate() + i);
	
				d.wdays.push({
					name: SCRM.str2date(date, 'wd'), // SCRM.toUpper1()
					wdid: 'wd'+ d.id +'v'+ i,
					//date: date,
					wd: date.getDay()
				});
			}
			if (typeof hwdValue === 'object') {
				pEDIT('idSportsmenSquad', {
					id: d.id,
					visitwdays: hwdValue.join(',')
				});
			} else {
				d.Avisitwdays = SCRM.val2array(d.visitwdays);
			}
        }
        
        return hasWD;
	},
	addInvoice: function(paymode, e){
		var opts = {
			sp: clubSpCard.sp,
            post: {
                sportsmen: clubSpCard.get()
            },
            paymode: paymode,
            payd: paymode,
            modal: {
                ok: SCRM.i18n.main.save
            }
        };
        SCRM._run('/chunk/invoice.new', opts);
    },
    repeatInvoice: function(){
        var selInvoice = clubSpCard.grinvoice
        	.data('srcData')[clubSpCard.selInvoice];
        console.log('selInvoice', selInvoice);
        var opts = {
            //val: selInvoice.typeinvoice,
            repeat: {
            	id: selInvoice.typeinvoice,
            	name: selInvoice.typeinvoice_name,
            	price: selInvoice.sum,
            	sportsmen: clubSpCard.get(),
                info: selInvoice.info
            }
            /*post: {
                //table: 'idInvoice',
                //typeinvoice: selInvoice.typeinvoice,
                sportsmen: clubSpCard.get(),
                info: selInvoice.info
            }*/
        };
        if (selInvoice.duedate) {
            opts.dateinvoice = new Date(selInvoice.duedate);
            opts.dateinvoice.setDate(opts.dateinvoice.getDate() + 1);  // след. день
        }
        SCRM._run('/chunk/invoice.new', opts);
    },
    linkPay: function(e) {
        pEDIT('idInvoicePay', {
            oper: 'add',
            idpay: clubSpCard.memPay,
            idinvoice: clubSpCard.selInvoice
        }, function(){
            clubSpCard.refreshTabs('#t_spPays,#t_spInvoice', true);
        });
    },
    recoverInvoice: function(e) {
        pEDIT('idInvoicePay', {
            oper: 'fix',
            id: clubSpCard.get()
        }, function(){
            clubSpCard.refreshTabs('#t_spInvoice', true);
        });
	},
	addSportsmenInvType: function(e, data){
		SCRM._run('/chunk/sp.invoiceTypeAdd', {
			sportsmen: clubSpCard.get(),
			discount: clubSpCard.sp.discount,
			city: clubSpCard.sp.city
		});
	},
	editSportsmenInvType: function(e, data){
    	e.preventDefault();
    	SCRM._run('/chunk/sp.invoiceTypeAdd', SCRM.mergeobj({
    		discount: clubSpCard.sp.discount,
			city: clubSpCard.sp.city
    	}, data.linkCtx.data));
    },
    deleteSportsmenInvType: function(e, data){
        pEDIT('idSportsmenInvType', {
            oper: 'del',
            id: data.linkCtx.data.id
        }, clubSpCard.refreshData);
    },
    spVisit: function(sp, e) {
        e.preventDefault();
        SCRM._run('/chunk/sp.visit', {
            sp: sp
        });
    },
    newTask: function(e, data) {
		SCRM.link(clubSpCard, 'TaskTab.hidden', false);
    	var sp = this.sp;
    	SCRM._run('/chunk/task', {
			idSportsmen: sp,
			taskPD: {
				tbl: 'sportsmen',
				parent: sp.id
			}
		});
    },
    idUserAdd: function(sp, e, data){
        SCRM._run('/chunk/user.new', {
            userLabel: SCRM.i18n.idSportsmen.contact,
            userName: sp.contact || sp.name,
            userEmail: sp.email,
            userCls: 'Sportsmen',
            userAdd: function(mdl) {
                var ed = {
                    id: sp.id,
                    email: mdl.userEmail,
                    user_role: mdl.userPermis
                };
                if (mdl.userName != sp.name) ed.contact = mdl.userName; // Не присваивать контакту имя Спорстмена
                return pEDIT('idSportsmen', ed, clubSpCard.refreshData);
            }
        });
    },
    idUserDisable: function(sp, e, data){
        SCRM.confirm(SCRM.i18n.login.offq, function(){
            pEDIT('idSportsmen', {
                id: sp.id,
                iduser: 0
            }, clubSpCard.refreshData);
        });
    },
    idUser: function(sp, e, data) {
        SCRM._run('/chunk/user.edit', {
            oper: 'edit',
            success: clubSpCard.refreshData,
            modal: true,
            id: sp.iduser
        });
    },
    cutPay: function(e, data) {
        SCRM.link(clubSpCard, {memPay: clubSpCard.selPay});
    },
    pastePay: function(e, data) {
        pEDIT('idPay', {
            oper: 'move',
            id: clubSpCard.memPay,
            sportsmen: clubSpCard.get()
        }, function(data){
            SCRM.link(clubSpCard, {memPay: data.id});
            clubSpCard.pnlSp.trigger('setROW.idSportsmen', {
                id: clubSpCard.get(),
                _saldo: true
            });
            // clubSpCard.refreshTabs('#t_spPays,#t_spInvoice', true);
        });
    },
    spClick: function(e) {
    	var el = $(e.currentTarget),
    		spCarD = this,
    		elData;
    	if (elData = el.data('spdtype')) {
    		e.preventDefault();
    		SCRM._run('/chunk/sp.duedate', {
                dtype: elData,
                spid: spCarD.get()
            });
    	}
    	if (elData = el.data('spdshow')) {
            var tabId = '#t_spDate',
	    		fld = {
					searchoptions: {
						defaultValue: elData
					}
				},
	    		gr = $('#grspdate', spCarD.pnlSp);
	    	if ( gr.hasClass('scrmGridLoaded') ) {
	    		gr
	    		.jqGrid('setColProp', 'dtype_name', fld)
	    		.jqGrid('setGridParam', {search: true})
	    		.jqGridFilterToolbar(true)
	    		.trigger('reloadGrid', [{page: 1}]);
	    		spCarD.ActiveTabs[ tabId ] = true; // Не перезагружать повторно при показе вкладки
	    	} else {
	    		fld.name = 'dtype_name';
				gr
				.one('jqGridBeforeInit', function(e, grOpts){
					grOpts.fltrToolbar = true;
					grOpts.addField(fld);
				});
	    	}
	    	$(tabId +' .showGridFilter', spCarD.pnlSp).hide();
	    	$('[href="'+ tabId +'"]', spCarD.sptabs).tab('show');
    	}
		// console.log('spClick', this, e);
	},
	setSCRMsp: function(sp) {
		SCRM.link(SCRM, {idSportsmen: sp});
		return !!(sp||{}).id;
	}
});

clubSpCard.eCardSpContact = $('.eCardSpContact', clubSpCard.pnlSp);
clubSpCard.pnlSp.trigger('scrmReady', ['spCard', clubSpCard]);
clubSpCard.sptabs = $('.sptabs', clubSpCard.pnlSp);

SCRM._service.spCard = function(sp_data, callback) {
    if (sp_data) {
        if (!sp_data.key && sp_data.sp) sp_data.key = sp_data.sp.key;
        if (clubSpCard.key != sp_data.key) {
        	clubSpCard.ActiveTabs = {};
            //$('[data-toggle="tab"]', clubSpCard.sptabs).addClass('calculate');
        }
    }
    SCRM.link(clubSpCard, sp_data);
    
    function cbAfterLoad() {
    	if (callback) callback(clubSpCard);
    	if (sp_data.addSpVisit) {
    		$('a[href="#t_spLessons"]', clubSpCard.pnlSp).click();
    		$('#addSpVisit', clubSpCard.pnlSp).click();
    	}
    }
    
    if (clubSpCard.key) {
        if (clubSpCard.cardHolder == 'modal') {
            if (!clubSpCard._mdl) {
                var _mdlData = {
                    //zindex: 1035,
                    cm_size: 'lg',
                    spCard: clubSpCard,
                    preventDestroy: true,
                    //jqGrid: true,
                    title: 'SportsmenCardTitle'
                };
                clubSpCard._mdl = club_Drawer(_mdlData);
            } else if (!clubSpCard._mdl.hasClass('show')) {
                clubSpCard._mdl.modal('show');
            }
            clubSpCard._mdl.find('.modal-body').append(clubSpCard.pnlSp);
        } else {
            clubSpCard.pnlSp.appendTo(clubSpCard.cardHolder);
        }

        clubSpCard.reloadData(cbAfterLoad);
    } else {
    	cbAfterLoad();
    }
};
SCRM._service[ '/handlers/spcard.html' ] = SCRM._service.spCard;

$(document)
.on('changeGridData.idSportsmen', function(e, params) {
    if ( clubSpCard.eqID(params) ) {
        clubSpCard.reloadData();
    }
})
.on('setROW.idSportsmen', function(e, params) {
    //console.log('setROW.idSportsmen', e, params);
    if ( clubSpCard.eqID(params) ) {
        SCRM.link(clubSpCard.sp, params);
        if (params._invoice) params._tab = '#t_spInvoice';
        if (params._event) params._tab = '#t_spEvents';
        if ( !params._tab &&
        	(params._saldo || params.SportsmenDate) ) {
        	params._tab = '#t_spPays,#t_spInvoice';
        }
        if (params._tab) {
            clubSpCard.refreshTabs(params._tab, true);
        }
        if ('trainer' in params || 'razr' in params || 'typeinvoice' in params) { // idcontact
            clubSpCard.reloadData();
        }
    }
});

SCRM.loadWSS('grid', function(){
	var spCardWhereSp = function(pd) {
	    var w = key2obj(pd, '_where', {});
	    w.sportsmen = clubSpCard.get();
	    return w;
	}
	
	clubSpCard.grinvoice = $('#grinvoice', clubSpCard.pnlSp)
	.data('srcData', true)
    .on('scrmRowAttr', function(e, data, cls, att) {
		if (data.sum == 0) {
			cls.push('rowArc');	return;
		}
		if (data.sumpay > 0){
            return cls.push( (data.sumpay*1 < data.sum*1)? 'rowWarn' : 'rowYes' );
        }
    })
    .on('jqGridAddEditBeforeShowForm', function(e, form) {
        $('#dateinvoice', form).prop('disabled', true); // hack для фокуса дл jqGridAddEditAfterShowForm
        var typeinvoice_name = $('#typeinvoice_name', form);
        typeinvoice_name.after('<b>'+ typeinvoice_name.val() +'</b>').remove();

        var duedate = $('#duedate', form).hide(),
        	rowId = $('#id_g', form).val(),
			row = $(this).data('srcData')[rowId];

        if (row && row.duedate) {
            $('<a href="#" class="dashed"></a>')
            .text( SCRM.str2date(row.duedate, 'd') )
            .insertAfter( duedate )
            .click(function(e){
            	e.preventDefault();
                $(this).closest('.ui-jqdialog').find('.ui-jqdialog-titlebar-close').click();
                SCRM._run('/chunk/invoice.lesson', {
                	spkey: row.sportsmen_key,
                	idinvoice: row.id
                });
            });
        } else {
        	duedate.closest('tr').hide();
        }
    })
    .on('jqGridAddEditAfterShowForm', function (e, form) {
        $('#sum', form).focus();
        $('#dateinvoice', form).prop('disabled', false); // hack для фокуса из jqGridAddEditBeforeShowForm
        $(this).data('istatus', $('#status', form).val() );
    })
    .on('jqGridAddEditAfterSubmit', function(e, jqXhrOrBool, postData, options) {
        if (postData.status &&
            postData.status != $(this).data('istatus') &&
            postData.status != clubSpCard.sp.status) {
	        SCRM.confirm('Сменить статус спортсмена с "'+ clubSpCard.sp.status +'" на "'+postData.status+'"?',
	        function() {
	            pEDIT('idSportsmen', {
	                status: postData.status,
	                id: clubSpCard.sp.id,
	                change_info: postData.info
	            }, clubSpCard.refreshData);
	        });
		}
    })
    .on('jqGridAddEditAfterComplete jqGridDeleteAfterComplete', function(e, rowid, jqXhrOrBool, postData, options) {
        clubSpCard.refreshTabs('#t_spPays', true);
        //updateSpSaldo('#tpays');
    })
    .on('GridSelectRows', function(e, data) {
        SCRM.link(clubSpCard, {
            selInvoice: data.selID||null
        });
    })
    .on('jqGridSerializeGridData', function(e, postData) {
        spCardWhereSp(postData);
    })
    .on('jqGridBeforeProcessing', function(e, data) {
        $.extend(data.userdata, {
            _sum: data.userdata.sum,
            maxdatepay: data.userdata.sumpay
        });
    })
	.one('reloadGrid', function(e){
	    var gr = $(this)
	    .jqGridInit({
	        sortname: 'dateinvoice', sortorder: 'desc',
	        footerrow: true, userDataOnFooter: true,
	        colModel:[
	            //{name: 'act', template: 'actions', width: 38},
	            {name: 'id', template: idFieldTemplate},
	            {name: 'typeinvoice_name', index: 'idInvoiceType.name', _label: 'main.type', width:120,
	                editable: 'readonly',
	                formatter: function(cv, options, row) {
	                    if (row.isauto == '1') cv = SCRM.fmtStatus({name: cv, ico: 'fa-toggle-on'}, {big: false});
	                    return SCRM.can('Invoice', 'edit')? editRowLinkFmt(cv, options, row) : cv;
	                },
	                unformat: function(cellValue, options, cell) {
	                    return $('a', cell).html();
	                }
	            },
	            {name: 'period_name', index: 'dateinvoice', _label: 'main.period', width: 70,
	                formatter: function(cellValue, options, row) {
	                    return (row.typeinvoice_period && row.dateinvoice)?
	                    	SCRM.str2date(row.dateinvoice, 'my')
	                        : '';
	                }
	            },
	            {name: 'dateinvoice', _label: 'main.date', template: dateTemplate,
	            	Required: true
	            },
	            {name: 'sum', _label: 'main.sum', index: 'idInvoice.sum', editable: true,
	                template: moneyTemplate,
	                formatter: function(cv, opts, row) {
	                    if (!opts.rowId) return SCRM.formatTotal(cv);
	                    var cVal = SCRM.format0Money(cv);
                        if (row.edited && !row.status && row.isauto==1) row.status = 'na';
                        if (row.status) cVal = SCRM.fmtStatus(row.status, {
                            tbl: 'idSportsmen', field: 'name', big: false,
                            tooltip: true, label: cVal
                        });
                        var oldSum = formatMoney(row.oldsum);
                        return !oldSum ? cVal : cVal+ '<br><small class="text-muted">'+oldSum+'</small>';
	                }
	            },
	            {name: 'status', _label: 'main.status', hidden: true,
	            	Ehidden: true,
	                edittype: 'select',
	                editoptions: {
	                    value: function(){
	                        var inv_status = $.map(SCRM.clubStatus.idSportsmen, function(v, i){
	                            if (SCRM.obj(v.extended).idInvoice) return {
	                                id: v.name,
	                                name: v.name
	                            };
	                        });
	                        inv_status.unshift({id: '', name: ''});
	                        return makeGridOpts(inv_status);
	                    }
	                },
	                formoptions: {
	                    label: SCRM.tmpl("{{:~i18n.main.status}} {{:~S.hintLink('invoice_status')}}")
	                }
	            },
	            
	            {name: 'info', template: infoTemplate, editable: true},
	            {name: 'maxdatepay', index: 'idPay.datepay', _label: 'main.pays',
	                width: 125, align: 'right',
	                template: dateTemplate, 
	                formatter: function(cv, options, row) {
	                    if (!options.rowId) {
	                        return formatMoney(row.sumpay);
	                    }
	                    var text = [ str2date(row.maxdatepay, 'd') ],
	                        sumpay = formatDigits( row.sumpay );
	                    if (text[0] && sumpay) {
	                        text.unshift( sumpay );
	                    }
	                    return text.join(' - ');
	                }
	            },
	            {name: 'ispaid', _label: 'main.payed', 
	                hidden: true,
	                template: publishedTemplate
	            },
	            {name: 'remain', _label: 'main.debt', width: 90,
	                hidden: true,
	                template: moneyTemplate
	            },
	            //{name:'sumpay', label:'Сумма оплачено', template: numberTemplate},
	            {name: 'duedate', index: 'duedate', _label: 'main.pass',
	                width: 105, align: 'right',
	                template: dateTimeTemplate,
	                formatter: function(cv, options, row){
	                    var diff = diffNow(row.duedate);
	                    if (row.duedate) {
	                        row.lesson_amount *= 1;
	                        row.rest_lesson = row.lesson_amount - (row.cnt_lesson||0)*1;
	                        row._cls = (diff < 0 && (row.rest_lesson > 0 || row.lesson_amount == 0))? 'text-success':'text-muted';
	                        row._restLsn = (row.lesson_amount > 0 || row.rest_lesson != 0)? row.rest_lesson : '';
	                        
	                        return SCRM.tmpl('<a href="#" data-spkey="{{:sportsmen_key}}" data-idinvoice="{{:id}}" data-run="/chunk/invoice.lesson" \
	                            class="{{:_cls}}">{{:_restLsn}} ~ {{formatDate:duedate}}</a>', row);
	                    }
	                    return '';
	                },
	                [[-
	                cell1attr: function(rowId, cellValue, data, cm, row){
	                    var cellCls = [ ], diff = diffNow(row.duedate);
	                    if (diff < 0 && (data.debt_lesson > 0 || data.lesson_amount == 0)) {
	                        cellCls.push('text-success');
	                    } else {
	                        cellCls.push('text-muted');
	                    }
	                },
	                ]]
	                editable: true,
	                unformat: function(text, d, td) {
	                    var rows = gr.data('srcData'),
	                        dd = (rows[ d.rowId ]||{}).duedate;
	                    return dd? str2date(dd, 'dt') : '';
	                }
	            },
	            {name: 'lesson_amount', _label: 'main.cnt', editable:true,
	            	template: intFieldTemplate,
	                hidden: true, hidedlg: true
	            },
	            {name: 'created', hidden: false, template: createdTemplate}
	        ],
	        actionsNavOptions: {
	            editbutton : false, 
	            delbutton : false, 
	            editformbutton: true
	        },
	        navOpts: {add: false, edit: SCRM.can('Invoice', 'edit'), del: SCRM.can('Invoice', 'del')},
	        btnColumns: true,
	        btnExport:true
	    });
	});
	
	$('#grpays', clubSpCard.pnlSp)
	.on('jqGridSerializeGridData', function(e, postData) {
		spCardWhereSp(postData);
	})
	.on('scrmRowAttr', function(e, data, cls, att) {
			if (data.sum < 0) {
				cls.push('rowArc');
				return;
			}
			if (data.code1c) cls.push('rowWarn');
    })
    .on('GridSelectRows', function(e, data) {
        SCRM.link(clubSpCard, {
            selPay: data.selID||null
        });
    })
    .on('jqGridAddEditSerializeEditData', function(e, data){
        if (data.oper=='add') data.sportsmen = clubSpCard.get();
    })
    .on('jqGridAddEditBeforeShowForm', function (e, form) {
        $('#datepay', form).prop('disabled', true);
    })
    .on('jqGridAddEditAfterShowForm', function (e, form, oper) {
        $('#sum', form).pauseFocus(true);
        $('#datepay', form).prop('disabled', false);
        if (oper == 'add') {
            $('#ptype', form).val(SCRM.clubStatus.idPayType_main);
        }
    })
    .on('jqGridAddEditAfterSubmit jqGridDeleteAfterComplete', function(e, rowid, jqXhrOrBool, postData, options) {
        clubSpCard.refreshTabs('#t_spInvoice', true);
        //updateSpSaldo('#tinvoice');
    })
	.one('reloadGrid', function(e){
	    $(this)
	    .jqGridInit({
	        sortname: 'datepay', sortorder: 'desc',
	        search: true,
	        footerrow: true, userDataOnFooter: true,
	        colModel: [
	            {name: 'id', hidden: true, template: idFieldTemplate},
	            {name: 'created', template: createdTemplate},
	            {name: 'datepay', _label: 'main.date', Required: true,
	                //formoptions: {rowpos: 1, colpos: 1},
	                template: dateTemplate,
	                sVal: true,
	                unformat: function(cellvalue, opts, cell) {
	                	return $(cell).text();
	                },
	                formatter: function (cv, opt, rowObject) {
						cv = '<b>'+ $.fn.fmatter.call(this, "date", cv, opt, rowObject)+'</b>';
	                    return SCRM.can('Pay', 'edit')? editRowLinkFmt(cv, opt, rowObject) : cv;
	                },
	                editoptions: {
	                    defaultValue: str2date('now', 'd')
	                }
	            },
	            {name: 'numpay', _label: 'idSportsmen.num', width: 90,
	            	//formoptions: {rowpos: 1, colpos: 2},
	            	editable: true
	            },
	            {name: 'sum', _label: 'main.sum',
	            	Required: true,
	                template: moneyTemplate,
	                editrules: {
	                    custom: true,
	                    custom_func: function(val, col) {
	                        return (val*1 == 0)? [false, 'sum == 0'] : [true,''];
	                    }
	                }
	            },
	            {name: 'info', width: 300, Ehidden: true, template: infoTemplate,
	            	sVal: true,
	            	formatter: limitHeightFormat
	            },
	            {name: 'ptype', _label: 'main.type', width: 50,
	                Required: true,
	                clubStatus: 'idPayType', lookupKey: 'alias',
	                template: gridLookSelTpl
	            },
	            {name: 'code1c', hidden: true, editable: true}
	        ],
	        navOpts: {
	        	add: SCRM.can('Pay', 'add'),
	        	edit: SCRM.can('Pay', 'edit'),
	        	del: SCRM.can('Pay', 'del')
	        },
	        btnColumns: true,
	        btnExport: true
	    });
	});
	
	$('#spLessons', clubSpCard.pnlSp)
	.one('reloadGrid', function(e){
	    var gr = $(this)
	    .on('jqGridSerializeGridData', function(e, postData) {
	        spCardWhereSp(postData);
	    })
	    .jqGridInit({
	        sortname: 'datestart', sortorder: 'desc',
	        search:true,
	        colModel:[
	            {name: 'id', hidden: true, template: idFieldTemplate},
	            {name: 'created', template: createdTemplate},
	            {name: 'stype_name', _label: 'main.type', index: 'schStatus.name', width: 55},
	            [[-{name: 'stype_ico', index: 'stype_name', _label: 'main.type',
	                width:40, align: 'center',
	                formatter: function(cv, opt, data){
	                    return (!cv)? '' : SCRM.fmtIco(cv+' text-muted', {
	                        add: 'title="'+ data.stype_name +'" data-toggle="tooltip"'
	                    });
	                }
	            },]]
	            {name: 'datestart', _label: 'main.dt', index: 'idSchedule.datestart', template: dateTimeTemplate},
	            {name: 'schedule_duration', _label: 'main.duration', index: 'idSchedule.duration', template: numberTemplate, width: 60, hidden: true},
	            
	            {name: 'status', _label: 'main.status', hidden: false, editable:true,
	                editrules: {edithidden:true},
	                width:40, align: 'center',
	                formatter: function(cv, opt, data){
	                	cv = SCRM.fmtStatus(data.status, {tbl: 'idLesson', label: false});
	                    return editRowLink(cv, opt.rowId);
	                },
	                template: gridLookSelAndNameTpl, //unformatter
	                clubStatus: 'idLesson', lookupKey: 'alias'
	            },
	            {name: 'mark', label: 'Оценка', width: 45, editable: true,
	                template: numberTemplate,
	                unformat: null
	            },
	            {name: 'trainer_name', index: 'idTrainer.name', _label: 'main.trainer', width: 90},
	            {name: 'club_name', index: 'idClub.name', _label: 'main.club', width: 90},
	            {name: 'sport_name', index: 'idSport.name', _label: 'main.sport', width: 90},
	            //{name:'levelname', index: 'idLevel.name', label:'Уровень', width: 40},
	            //{name:'squadname', index: 'idSquad.name', label:'Группа', width: 70},
	            
	            {name: 'level_name', index: 'idLevel.name', _label: 'main.level', width: 50,
					formatter: function(value, options, rData){
						return SCRM.fmtSq(rData);
					},
					_attr: function(rowId, cellValue, obj) {
						key2obj(obj.Attr, 'colspan', '2');
					}
	            },
	            {name: 'squad_name', index: 'idSquad.name', _label: 'main.squad', width: 80,
	            	_attr: function(rowId, cellValue, obj) {
						key2obj(obj.Attr, 'style').push('display:none;');
					}
	            },
	            {name: 'dateinvoice', _label: 'main.pass', template: dateTimeTemplate,
	            	index: 'idInvoice.dateinvoice',
	                formatter: function(value, options, rData){
						return SCRM.fmtInvoiceLessonLink(rData.dateinvoice, rData.idinvoice, clubSpCard.key);
	                }
	            },
	            {name: 'info', template: infoTemplate, editable: true}
	        ],
	        navOpts: {add: false, edit: true, del: true},
	        btnColumns: true,
	        btnExport:true
	    })
	    .on('scrmRowAttr', function(e, row, cls, att) {
	    	row.wo_invoice = ((row.cfg_value||'').indexOf(row.status) > -1) && !row.dateinvoice; // TODO
	        if (row.wo_invoice) cls.push('table-warning');
	    })
	    .on('jqGridAddEditAfterSubmit jqGridDeleteAfterComplete', function(e, rowid, jqXhrOrBool, postData, options) {
	        clubSpCard.refreshTabs('#t_spInvoice', true);
	    })
	    .on('jqGridAddEditAfterShowForm', function (e, form, op, ddd) {
	        var input = $('#status', form).attr('data-link', 'status').hide();
	
	        var se = {
	            status: input.val(),
	            statusEd: '<a href="#" class="btn btn-sm btn-secondary prevent-default" tabIndex="-1" \
	                data-link="class{merge:(~st==alias) toggle=\'active\'} {on ~chStatus}"> \
	                {{fmtStIco:alias tbl="idLesson"}}</a>',
	            lsn: SCRM.clubStatus.idLesson
	        };
	        $('<div><div class="btn-group btn-group-toggle" data-link="{for lsn ~st=status tmpl=statusEd}"></div></div>')
	        .insertAfter(input).append(input)
	        .link(true, se, {
	            chStatus: function(e, data) {
	                SCRM.link(se, {status: data.linkCtx.data.alias});
	            }
	        });
	    });
	});
	
	$('#grchanges', clubSpCard.pnlSp)
	.one('reloadGrid', function(e){
		var canEd = SCRM.can('Admin') || SCRM.can('SpChanges', 'edit');
	    $(this)
	    .on('jqGridSerializeGridData', function(e, postData) {
	        spCardWhereSp(postData);
	    })
	    .jqGridInit({
	        sortname: 'created', sortorder: 'desc',
	        colModel: [
	            {name: 'id', template: idFieldTemplate},
	            {name: 'created', hidden: false, template: createdTemplate},
	            {name: 'username', width: 100, hidden: true},
	            {name: 'chfield', label: 'Поле', width: 80, editable: 'readonly',
	                formatter: function (cellValue, options, rowObject) {
	                    var name = SCRM.i18n.idSportsmen[cellValue] || SCRM.i18n.main[cellValue] || cellValue;
	                    return name;
	                }
	            },
	            {name: 'newvalue', _label: 'main.val', width: 150,
	            	editable: SCRM.can('Admin') ? true : 'readonly'
	            },
	            {name: 'oldvalue', hidden: true},
	            {name: 'info', width: 300, template: infoTemplate,
	            	Ehidden: true, sVal: true,
	            	formatter: limitHeightFormat
	            }
	        ],
	        navOpts: {add: false, edit: canEd, del: false, search: false},
	        fltrToolbar: true,
	        btnColumns: true
	    });
	});
	
	$('#grspdate', clubSpCard.pnlSp)
	.on('jqGridSerializeGridData', function(e, postData) {
        spCardWhereSp(postData);
    })
	.on('jqGridAddEditAfterComplete jqGridDeleteAfterComplete', function(e, rowid, jqXhrOrBool, postData, options) {
        clubSpCard.pnlSp.trigger('setROW.idSportsmen', {
            id: clubSpCard.get(),
            SportsmenDate: true
        });
    })
	.one('reloadGrid', function(e){
	    var gr = $(this)
	    .jqGridInit({
	        sortname: 'duedate', sortorder: 'desc',
	        colModel: [
	            {name: 'id', template: idFieldTemplate},
	            {name: 'dtype_name', _label: 'main.type', template: soptEqTemplate,
	                editable: 'readonly'
	            },
	            {name: 'datestart', _label: 'main.begin', template: dateTemplate, 
	                Ehidden: true
	            },
				{name: 'duedate', _label: 'main.end', template: dateTemplate,
					Required: true,
					_attr: function(rowId, cellValue, obj) {
						var cls = SCRM.empty(obj.has_duedate) ? 'text-muted' :
							SCRM.spDuedateColor(cellValue, obj.dtype);
						if (cls) key2obj(obj.Attr, 'class').push(cls);
	                }
	            },
	            {name: 'val', _label: 'main.val', editable: false},
	            //{name: 'has_duedate'},
	            {name: 'created', hidden: true, template: createdTemplate},
	            {name: 'info', template: infoTemplate, editable: true}
	        ],
	        search: true,
	        navOpts: {add: false, edit: true, del: true},
	        btnColumns: true
	    });
	    
	    $(document)
	    .on('setROW.idSportsmen', function(e, params) {
	    	if ( clubSpCard.eqID(params)
	    		&& params.SportsmenDate && e.target !== gr[0] ) {
	    		gr.trigger('reloadGrid');
	    	}
		});
	});
	
	var grEvm = $('#spEventSportsmen', clubSpCard.pnlSp);
	
	var spEvent = $('#spEvent' + clubSpCard._id)
	.on('jqGridSerializeGridData', function(e, postData) {
        var w = key2obj(postData, '_where', {});
        w['idEventMember.sportsmen'] = clubSpCard.get();
    })
    .on('jqGridAfterLoadComplete', function(e, data) {
        // Если среди данных нет турнира, то обнулить и снять выделения чтобы спрятать Ивенты
        if (clubSpCard.selSpEvent) {
            spEvent.data('selID', clubSpCard.selSpEvent.id);
        }
    })
    .on('GridSelectRows', function(e, data) {
        console.log('spEventSelectRows', data)
        var grid = $(this),
        nd = {
            selEventID: data.selID||0
        };
        if (nd.selEventID) nd.selSpEvent = grid.jqGrid('getRowData', nd.selEventID);
        SCRM.link(clubSpCard, nd);
        if (nd.selEventID) grEvm.trigger('reloadGrid');
    })
	.one('reloadGrid', function(e){
	    spEvent
	    .jqGridInit({
	        sortname: 'datestart', sortorder: 'desc',
	        colModel:[
	            {name: 'id', hidden: true, template: idFieldTemplate},
	            {name: 'status', _label: 'main.type', width: 80},
	            {name: 'name', _label: 'main.name', width: 220,
	                classes: 'text-wrap'
	            },
	            {name: 'location', _label: 'idEvent.location', width: 200, hidden: true,
	            	classes: 'text-wrap'
	            },
	            {name: 'datestart', _label: 'main.begin', template: dateTemplate},
	            {name: 'dateend', _label: 'main.end', template: dateTemplate}
	        ],
	        navOpts: {add:false, edit:false, del:false, search:false},
	        //fltrToolbar: true,
	        btnColumns: true
	    });
	    
	    grEvm
	    .on('jqGridSerializeGridData', function(e, postData) {
            var w = spCardWhereSp(postData);
            w.idevent = clubSpCard.selEventID;
        })
        .on('jqGridDeleteAfterComplete', function(e, rowid, jqXhrOrBool, postData, options) {
            grEvm.one('jqGridLoadComplete', function(e, data) {
                if (!data.rows.length) spEvent.trigger('reloadGrid');
            });
        })
	    .one('reloadGrid', function(e){
	    	grEvm
	        .jqGridInit({
	            //datatype: 'local', datatype: 'json',
	            rowList: false, pginput: false,
	            sortname: 'name', sortorder: 'asc',
	            colModel: [
	                {name: 'id', template: idFieldTemplate},
	                {name: 'created', template: createdTemplate},
	                {name: 'team', _label: 'idEvent.team', width: 80, editable: true},
	                {name: 'eventcategory_name', index: 'idEventCategory.name', _label: 'idEvent.category', width: 150},
	                {name: 'place', _label: 'idEvent.place', width: 70,
	                    editable: true,
	                    align: 'center'
	                },
	                {name: 'result', _label: 'idEvent.result', width: 70,
	                    editable: true,
	                    template: numberTemplate
	                },
	                {name: 'act', template: 'actions', width: 55}
	            ],
	            actionsNavOptions: {
	                delbutton: false
	            },
	            navOpts: {add: false, edit: false, del: true, search: false},
	            btnColumns: true
	        });
	    });
	});
});
</script>