{"data":[{"id":"cce036ac-669b-4d3f-8ff7-05ffe343dd7b","source":"cc-execution","status":"waiting_for_gate","payload":{"ok":true,"jobId":null,"phase":"objective_received","branch":"ai/big-papis-self-service-hardening-0919","reason":"provider_verified_auto_progress_owns_gate_merge_release_outside_owner_response","status":"waiting_for_gate","metrics":{"receiptBytes":0,"releaseCount":0,"toolCallCount":0,"repeatedCallCount":0,"ownerInterruptionCount":0},"version":"1.58.182-witness-render-cold-start-aware","prNumber":3197,"terminal":false,"missionId":"bbe1033f-2c95-4ad4-ad36-fd64c65a7b9d","operation":"execute_mission","proofGate":"repair_mission_pr_handed_off_to_supervisor","sourceSha":null,"timingsMs":{"gateMs":0,"proofMs":0,"handlerMs":9696,"releaseMs":0,"mutationMs":0,"repositoryMs":0,"prReadinessMs":0,"approvedPlanMs":2961,"missionSetupMs":348,"providerAuthMs":0,"shipAndProveMs":0,"ledgerPrepareMs":348,"ledgerReconcileMs":0,"lineageReconcileMs":0,"resolvePreflightMs":348,"repositoryMutationMs":6735,"repositoryProviderMs":6735,"authoritativeLedgerMs":0,"ledgerAsyncDispatchMs":0,"repositoryAtomicCommitMs":4529,"repositoryBranchCreateMs":0,"totalSynchronousLedgerMs":348,"asyncBookkeepingDispatchMs":0,"ledgerAuthoritativeCommitMs":0,"repositoryPullRequestCreateMs":2206},"nextAction":"Canonical KnockLaunch Gate notifier and durable mission supervisor own Gate, merge, release, and proof progression from this exact PR head outside the owner response path.","receiptRef":{"mode":"full","missionId":"bbe1033f-2c95-4ad4-ad36-fd64c65a7b9d"},"performance":null,"deploymentId":null,"releaseState":null,"workflowRunId":null,"releaseTargets":null,"detailsAvailable":true,"ownerFacingState":"IN_PROGRESS","pendingProofKinds":[],"verificationState":null,"workflowInvariant":{"oneBranch":true,"oneMission":true,"oneRelease":true,"invariantScope":"repair_generation","onePullRequest":true,"terminalProofRequired":true,"correctiveGenerationsAllowed":true},"sourceReceiptBytes":4187,"ownerActionRequired":false,"ownerFacingTerminal":false,"continuationRequired":true,"requestContractState":"pending"},"tenant_id":"a3ffa31f-0c88-4fdd-b872-051db013ca3e","created_at":"2026-09-19T12:27:08.224509+00:00","proof_gate":"repair_mission_pr_handed_off_to_supervisor","source_sha":null,"external_id":"3197","receipt_type":"execute_mission","idempotency_key":"mission:bbe1033f-2c95-4ad4-ad36-fd64c65a7b9d:execute_mission:repair_mission_pr_handed_off_to_supervisor:current-generation","mission_step_id":"d17b7430-be69-4eb5-9eef-91f9657007c0","command_center_event_id":"bbe1033f-2c95-4ad4-ad36-fd64c65a7b9d"},{"id":"cce05ed1-3fc4-45b2-ae70-21559deaa14d","source":"cc-execution","status":"waiting_for_gate","payload":{"ok":true,"jobId":null,"phase":"objective_received","branch":"ai/witness-render-cold-start-aware","reason":"provider_verified_auto_progress_owns_gate_merge_release_outside_owner_response","status":"waiting_for_gate","metrics":{"receiptBytes":0,"releaseCount":0,"toolCallCount":0,"repeatedCallCount":0,"ownerInterruptionCount":0},"version":"1.58.181-visual-witness-capacity-pool","prNumber":3063,"terminal":false,"missionId":"7217f76f-b25d-49fb-adce-7ca8e5123e2a","operation":"execute_mission","proofGate":"repair_mission_pr_handed_off_to_supervisor","sourceSha":null,"timingsMs":{"gateMs":0,"proofMs":0,"handlerMs":23149,"releaseMs":0,"mutationMs":0,"repositoryMs":0,"prReadinessMs":0,"approvedPlanMs":13632,"missionSetupMs":2753,"providerAuthMs":0,"shipAndProveMs":0,"ledgerPrepareMs":2753,"ledgerReconcileMs":0,"lineageReconcileMs":0,"resolvePreflightMs":2753,"repositoryMutationMs":9517,"repositoryProviderMs":9517,"authoritativeLedgerMs":0,"ledgerAsyncDispatchMs":0,"repositoryAtomicCommitMs":5981,"repositoryBranchCreateMs":0,"totalSynchronousLedgerMs":2753,"asyncBookkeepingDispatchMs":0,"ledgerAuthoritativeCommitMs":0,"repositoryPullRequestCreateMs":3536},"nextAction":"Canonical KnockLaunch Gate notifier and durable mission supervisor own Gate, merge, release, and proof progression from this exact PR head outside the owner response path.","receiptRef":{"mode":"full","missionId":"7217f76f-b25d-49fb-adce-7ca8e5123e2a"},"performance":null,"deploymentId":null,"releaseState":null,"workflowRunId":null,"releaseTargets":null,"detailsAvailable":true,"ownerFacingState":"IN_PROGRESS","pendingProofKinds":[],"verificationState":null,"workflowInvariant":{"oneBranch":true,"oneMission":true,"oneRelease":true,"invariantScope":"repair_generation","onePullRequest":true,"terminalProofRequired":true,"correctiveGenerationsAllowed":true},"sourceReceiptBytes":4282,"ownerActionRequired":false,"ownerFacingTerminal":false,"continuationRequired":true,"requestContractState":"pending"},"tenant_id":"a3ffa31f-0c88-4fdd-b872-051db013ca3e","created_at":"2026-09-18T01:31:20.631373+00:00","proof_gate":"repair_mission_pr_handed_off_to_supervisor","source_sha":null,"external_id":"3063","receipt_type":"execute_mission","idempotency_key":"mission:7217f76f-b25d-49fb-adce-7ca8e5123e2a:execute_mission:repair_mission_pr_handed_off_to_supervisor:current-generation","mission_step_id":"45c5517c-ebde-45ba-b754-94eb30c0d15d","command_center_event_id":"7217f76f-b25d-49fb-adce-7ca8e5123e2a"},{"id":"cce0b0ae-9abe-4936-8108-16b14fcbc778","source":"cc-execution","status":"deployment_dispatched","payload":{"ok":true,"jobId":null,"phase":"release","branch":"ai/release-promotion-visible-bundle-20260910","reason":null,"status":"deployment_dispatched","metrics":{"receiptBytes":0,"releaseCount":1,"toolCallCount":0,"repeatedCallCount":0,"ownerInterruptionCount":0},"version":null,"prNumber":2319,"terminal":false,"missionId":"9a23a2c9-c8e8-4366-b29f-53e4cb0f9f43","operation":"automatic_mission_resume","proofGate":"canonical_release_dispatched","sourceSha":"ef9ef5bd87afae514627184a197cfda05204c0f3","timingsMs":{"prReadinessMs":662,"approvedPlanMs":0,"shipAndProveMs":16202,"repositoryMutationMs":0,"repositoryProviderMs":0,"repositoryAtomicCommitMs":0,"repositoryBranchCreateMs":0,"repositoryPullRequestCreateMs":0},"nextAction":null,"receiptRef":{"mode":"full","missionId":"9a23a2c9-c8e8-4366-b29f-53e4cb0f9f43"},"performance":null,"deploymentId":"forgejo-main-ef9ef5bd87af","workflowRunId":6832,"releaseTargets":{"frontend":true,"onrunner":false,"migrations":false,"ccExecution":true,"supabaseEdge":false,"edgeFunctionSlugs":[]},"detailsAvailable":true,"ownerFacingState":"IN_PROGRESS","workflowInvariant":{"oneBranch":true,"oneMission":true,"oneRelease":true,"invariantScope":"repair_generation","onePullRequest":true,"terminalProofRequired":true,"correctiveGenerationsAllowed":true},"sourceReceiptBytes":2212,"ownerActionRequired":false,"ownerFacingTerminal":false,"continuationRequired":true},"tenant_id":"a3ffa31f-0c88-4fdd-b872-051db013ca3e","created_at":"2026-09-10T20:05:56.503368+00:00","proof_gate":"canonical_release_dispatched","source_sha":null,"external_id":"2319","receipt_type":"automatic_mission_resume","idempotency_key":"mission:9a23a2c9-c8e8-4366-b29f-53e4cb0f9f43:automatic-mission-resume:2319:canonical_release_dispatched","mission_step_id":"d3859928-9dd1-47b4-afa7-3cd3b5658184","command_center_event_id":"9a23a2c9-c8e8-4366-b29f-53e4cb0f9f43"},{"id":"cce34840-ca9a-46b3-af71-e5cf7426c7d9","source":"cc-execution","status":"recorded","payload":{"requestContract":{"valid":true,"intent":{"evidence":[],"confidence":null,"compilation":{"stages":["owner_intent","conversation_context","scope","live_state","mutation_authority","affected_systems","dependencies","risk_and_blast_radius","execution_tactics","required_proof","release_plan","recovery_plan"],"version":2,"explicit":true,"objective":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","proofKinds":["repository"],"adaptiveDomains":["intent","tenant_route_role_viewport","urgency_deadline","dependency_scope","risk_blast_radius","runner_capacity","queue_active_work","provider_failure_circuits","qa_scope","retry_recovery","release_ownership","proof_depth"],"expansionPolicy":"later_stages_may_only_narrow_or_expand_with_machine_readable_dependency_evidence","dynamicStatePolicy":"live_state_may_change_execution_tactics_but_never_owner_outcome_or_explicit_constraints","dynamicRefreshStages":["preflight","gate","release","runtime_proof"],"adaptiveCompilerVersion":"paul-adaptive-objective-v1","inheritedContextBlockingAuthority":false},"rawUtterance":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","wordingChanged":false,"canonicalIntent":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","resolutionStatus":"exact","uniqueResolution":true,"clarificationRequired":false},"source":"explicit","version":1,"outcomes":[{"id":"outcome-1","statement":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","provenance":{"reason":null,"source":"current_request_inference","inherited":false,"blockingAuthority":true},"proofConditionIds":["proof-production"]}],"objective":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","constraints":[{"id":"capability-completeness","statement":"Every dependency the implementation declares or relies on must be wired and proven across applicable frontend, backend/runtime, schema/data/storage, authentication/authorization, provider configuration, prerequisite/loading/empty/error states, release ownership, and live production behavior; owner-authorized unavailable dependencies must become explicit prerequisite states rather than runtime failures.","provenance":{"reason":null,"source":"heuristic_current_objective","inherited":false,"blockingAuthority":true},"proofConditionIds":["proof-production"]},{"id":"atomic-capability-lifecycle","statement":"Changed capabilities remain non-active until dependency readiness, N/N-1 compatibility, affected-target release, and claim-matched production canary proof are satisfied; missing optional dependencies become prerequisite_required, and runtime drift or health-contract violation quarantines only the affected capability instead of breaking unrelated working capability.","provenance":{"reason":null,"source":"heuristic_current_objective","inherited":false,"blockingAuthority":true},"proofConditionIds":["proof-production"]}],"adaptivePolicy":{"risk":{"tier":"bounded","blastRadius":"narrow"},"proof":{"requiredKinds":["repository"],"visualProofScope":"none","interactionRequired":false,"runtimeProofRequired":true},"scope":{"route":null,"roleRef":null,"tenantRef":null,"sourceTargets":["src/pages/card-grading/PCGReceiveCardsGallery.tsx"]},"dynamic":{"variables":["main_and_runtime_lineage","runner_capacity","queue_and_active_work","provider_health","failure_clusters_and_circuits","release_target_state","current_pr_and_gate_state"],"refreshStages":["preflight","gate","release","runtime_proof"],"refreshMayChange":["runner_selection","parallelism","retry_path","qa_depth","release_recovery","proof_timing"],"refreshMayNotChange":["owner_outcome","explicit_no_go_constraints","tenant_identity","credential_boundary","hard_safety_invariants"]},"urgency":{"priority":"normal","deadlineSignals":[],"deadlineExplicit":false},"version":"paul-adaptive-objective-v1","recovery":{"transient":"one_bounded_retry_then_alternate_eligible_pool_or_provider_path","deterministic":"repair_source_or_contract_do_not_blind_rerun","mutationDependencyFailure":"prerequisite_required_or_targeted_recovery_never_invent","readOnlyDependencyFailure":"degrade_to_available_grounded_context_and_keep_conversation_alive"},"unknowns":["tenant","route","deadline"],"authority":{"outcome":"current_explicit_owner_request","tactics":"live_prime_truth","unknownPolicy":"preserve_unknown_never_invent","historicalContext":"advisory_unless_current_request_confirms"},"execution":{"mutation":true,"concurrency":"parallel_non_overlapping_work","scopePolicy":"start_bounded_expand_only_with_machine_readable_dependency_evidence","staleStatePolicy":"refresh_dynamic_state_before_irreversible_or_acceptance_stage","conversationIsolation":true,"ownerOutcomeMayBeChangedByAdaptation":false},"experience":{"visual":false,"viewports":["desktop","mobile"],"behavioral":false,"visualProofScope":"none"},"dependencies":{"requiredDomains":["frontend","backend_runtime","release_ownership","live_production_proof"],"capabilityDomains":["frontend","backend_runtime","schema_data_storage","authentication_authorization","provider_configuration","prerequisite_loading_empty_error_states","release_ownership","live_production_proof"],"releaseTargetHints":["frontend"]},"inputSignals":{"rawUtterance":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","canonicalIntent":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","conversationContextPresent":false}},"terminalPolicy":"all_required_proof_conditions_satisfied_after_live_release","proofConditions":[{"id":"proof-production","kind":"repository","claim":"Continue the same exact-source PCG Card Intake P0 mission with the synthesized current-main file write, then Gate, merge, deploy, and verify live.","route":null,"roleRef":null,"userRef":null,"required":true,"expectedText":null,"targetedActions":[],"allowedReleaseTargets":[],"requiredReleaseTargets":[],"requireCapacityAdmissible":false,"expectedWatchdogPolicyVersion":null,"minConsecutiveHealthyHeartbeats":1,"requirePositiveMemoryAttribution":false,"requireMemoryAdmissionPressureFalse":false}],"validationErrors":[],"capabilityManifest":{"id":"Continue-the-same-exact-source-PCG-Card-Intake-P0-mission-with-the-synthesized-current-main-file-wri","driftPolicy":"exact_manifest_source_release_dependency_or_runtime_identity_mismatch_is_nonterminal","proofLedger":"command_center_mission_ledger_request_contract_hash_bound","schemaVersion":1,"releaseTargets":[],"lifecycleStates":["prepare","deploy","verify","activate"],"activationPolicy":"dependencies_and_claim_matched_live_proof_before_exposure","dependencyDomains":["frontend","backend_runtime","schema_data_storage","authentication_authorization","provider_configuration","prerequisite_loading_empty_error_states","release_ownership","live_production_proof"],"prerequisitePolicy":"expected_unavailable_dependencies_are_prerequisite_required_not_runtime_failures","compatibilityWindow":["N","N-1"],"failureIsolationPolicy":"quarantine_or_rollback_affected_capability_only_preserve_unrelated_working_capabilities","canaryProofConditionIds":["proof-production"]},"capabilityCompleteness":{"domains":["frontend","backend_runtime","schema_data_storage","authentication_authorization","provider_configuration","prerequisite_loading_empty_error_states","release_ownership","live_production_proof"],"required":true,"prerequisitePolicy":"expected_unavailable_dependencies_are_prerequisite_states_not_runtime_failures"}},"requestContractHash":"7ac5cb73db02f00a97a5d808060b3a3d02c2a82787c71d07d479ece758fe107f","requestContractRevision":2,"previousRequestContractHash":"4a18ce0eb8b6cf7f2d8ed99314db05c9d2a17c348e1390b5fcd89649201fb913"},"tenant_id":"a3ffa31f-0c88-4fdd-b872-051db013ca3e","created_at":"2026-10-06T14:32:11.392599+00:00","proof_gate":"request_contract_revision_recorded","source_sha":null,"external_id":null,"receipt_type":"request_contract_revision","idempotency_key":"mission:e972f636-ee12-4fce-8ba0-6b156b3a2584:request-contract:7ac5cb73db02f00a97a5d808060b3a3d02c2a82787c71d07d479ece758fe107f","mission_step_id":"3ee65265-1ffb-4895-bce5-f2bdb5a9d7ca","command_center_event_id":"e972f636-ee12-4fce-8ba0-6b156b3a2584"},{"id":"cce38e37-0a2f-4716-a8f5-11e6d797cf58","source":"cc-execution","status":"waiting","payload":{"body":{"ship":true,"files":[{"path":"src/pages/card-grading/PCGWorkspace.tsx","content":"import React,{useEffect,useRef,useState} from 'react';\nimport {Archive,ArrowUpRight,CheckCircle2,Database,Download,FileSpreadsheet,FileWarning,ImagePlus,Layers3,Loader2,PackageCheck,PauseCircle,Radar,RefreshCw,ScanLine,ShieldCheck,UploadCloud,XCircle} from 'lucide-react';\nimport {supabase} from '@/integrations/supabase/client';\nimport {useMultiTenant} from '@/contexts/MultiTenantContext';\nimport {useToast} from '@/hooks/use-toast';\nimport {CRMShell} from '@/components/crm/CRMShell';\nimport {cn} from '@/lib/utils';\nimport PCGGrowthLab,{PCGGrowthPulse} from '@/pages/card-grading/PCGGrowthLab';\nconst DRIVE_MEDIA_FN=`${import.meta.env.VITE_SUPABASE_URL}/functions/v1/pcg-google-drive-media`;const CONCURRENCY=4;type DriveMedia={url:string;fileId:string};\ntype CsvRow=Record;type BatchItem={key:string;front?:File;back?:File;row?:CsvRow;status:'queued'|'uploading'|'done'|'failed';error?:string};type CardForm={title:string;player:string;year:string;set:string;number:string;category:string;grader:string;grade:string;cert:string;condition:string;qty:string;cost:string;value:string;tags:string;notes:string};type StoredCard={id:string;player_character?:string|null;brand_set?:string|null;year?:string|null;card_number?:string|null;front_image_url?:string|null;grade?:number|null;cert_number?:string|null;metadata?:Record|null};type SubmissionOption={id:string;submission_number:string;customer_name:string|null;status:string};type DriveState='checking'|'ready'|'missing'|'reconnect';type ExistingBatchCard={id:string;sequence_number:number;import_key:string|null;front_image_url:string|null;back_image_url:string|null};type VaultMode='overview'|'single'|'batch'|'migration'|'growth';\nconst LEGACY_FIELD_DEFS=[\n{key:'submission_number',label:'Order / submission #',aliases:['submission_number','submission','order_number','order','order_id','submission_id','invoice_number']},\n{key:'legacy_id',label:'Legacy record ID',aliases:['legacy_id','record_id','id','card_id','item_id','entry_id']},\n{key:'customer_name',label:'Customer name',aliases:['customer_name','customer','collector_name','collector','client_name','name']},\n{key:'customer_email',label:'Customer email',aliases:['customer_email','email','collector_email','client_email']},\n{key:'customer_phone',label:'Customer phone',aliases:['customer_phone','phone','telephone','collector_phone','client_phone']},\n{key:'service_tier',label:'Service tier',aliases:['service_tier','tier','service','turnaround']},\n{key:'service_price',label:'Service price',aliases:['service_price','price','order_total','total','amount']},\n{key:'submission_status',label:'Order status',aliases:['submission_status','order_status','status','workflow_status']},\n{key:'payment_status',label:'Payment status',aliases:['payment_status','paid','payment','payment_state']},\n{key:'delivery_method',label:'Delivery method',aliases:['delivery_method','delivery','fulfillment','return_method']},\n{key:'tracking_in',label:'Inbound tracking',aliases:['tracking_in','tracking_number_in','inbound_tracking']},\n{key:'tracking_out',label:'Outbound tracking',aliases:['tracking_out','tracking_number','tracking','outbound_tracking']},\n{key:'submission_notes',label:'Order notes',aliases:['submission_notes','order_notes','customer_notes']},\n{key:'received_at',label:'Received date',aliases:['received_at','received_date','date_received','submitted_at','created_at']},\n{key:'due_at',label:'Due date',aliases:['due_at','due_date','target_date']},\n{key:'completed_at',label:'Completed date',aliases:['completed_at','completed_date','date_completed']},\n{key:'sequence_number',label:'Card sequence',aliases:['sequence_number','sequence','item_number','line_number']},\n{key:'cert_number',label:'Certification / serial',aliases:['cert_number','cert','certificate','serial','serial_number']},\n{key:'category',label:'Sport / category',aliases:['category','sport','type']},\n{key:'year',label:'Year',aliases:['year','card_year']},\n{key:'brand_set',label:'Set / brand',aliases:['brand_set','set','brand','card_set']},\n{key:'player_character',label:'Player / subject',aliases:['player_character','player','subject','character','athlete']},\n{key:'card_number',label:'Card number',aliases:['card_number','card_no','number']},\n{key:'variation',label:'Variation',aliases:['variation','variant','parallel']},\n{key:'card_description',label:'Card description',aliases:['card_description','description','title','card_title']},\n{key:'declared_value',label:'Declared / estimated value',aliases:['declared_value','estimated_value','value','card_value']},\n{key:'grade',label:'Grade',aliases:['grade','score','numeric_grade']},\n{key:'grade_label',label:'Grade label / condition',aliases:['grade_label','condition','condition_label']},\n{key:'card_status',label:'Card status',aliases:['card_status','item_status','grading_status']},\n{key:'grader_notes',label:'Card / grader notes',aliases:['grader_notes','card_notes','notes']},\n{key:'front_source',label:'Legacy front image ref',aliases:['front_source','front_image','front_image_url','front','image_front']},\n{key:'back_source',label:'Legacy back image ref',aliases:['back_source','back_image','back_image_url','back','image_back']}\n] as const;\ntype LegacyFieldKey=typeof LEGACY_FIELD_DEFS[number]['key'];type LegacyMapping=Record;type LegacyIssue={row:number;severity:'error'|'warning';field:string;message:string};type LegacyPlan={rowNumber:number;source:CsvRow;submission:Record;card:Record;importKey:string;issues:LegacyIssue[];duplicate:boolean;existingSubmissionId?:string|null};type LegacyDryRun={plans:LegacyPlan[];issues:LegacyIssue[];summary:{rows:number;customers:number;submissions:number;newSubmissions:number;existingSubmissions:number;cards:number;safeCards:number;duplicates:number;conflicts:number;warnings:number;mediaRefs:number}};\nconst LEGACY_STATUS_MAP:Record={new:'received',submitted:'received',received:'received',intake:'intake_imaging',intake_imaging:'intake_imaging',imaging:'intake_imaging',authentication:'authentication',auth:'authentication',grading:'grading',graded:'grading',encapsulation:'encapsulation',encapsulated:'encapsulation',slabbing:'encapsulation',qa:'qa',quality_assurance:'qa',ready:'ready',complete:'ready',completed:'ready',finished:'ready',shipped:'shipped',mailed:'shipped',delivered:'shipped',picked_up:'picked_up',pickup:'picked_up'};\nconst LEGACY_TIER_MAP:Record={two_weeks:'two_weeks','2_weeks':'two_weeks','14_days':'two_weeks',one_week:'one_week','1_week':'one_week','7_days':'one_week',three_days:'three_days','3_days':'three_days',same_day:'same_day',sameday:'same_day',inventory:'inventory'};\nconst LEGACY_PAYMENT_MAP:Record={unverified:'unverified',unpaid:'unverified',pending:'unverified',paid:'manually_verified',complete:'manually_verified',completed:'manually_verified',succeeded:'manually_verified',manually_verified:'manually_verified',waived:'waived',free:'waived',refunded:'refunded',refund:'refunded'};\nconst LEGACY_DELIVERY_MAP:Record={walk_in:'walk_in',walkin:'walk_in',dropoff:'walk_in',drop_off:'walk_in',mail_in:'mail_in',mail:'mail_in',ship_back:'ship_back',shipping:'ship_back',shipped:'ship_back',pickup:'pickup',pick_up:'pickup'};\n\nconst EMPTY_FORM:CardForm={title:'',player:'',year:'',set:'',number:'',category:'',grader:'',grade:'',cert:'',condition:'',qty:'1',cost:'',value:'',tags:'',notes:''};\nconst fileStem=(name:string)=>name.replace(/\\.[^.]+$/,'').replace(/[-_ ](?:front|back|obverse|reverse)$/i,'');const isBack=(name:string)=>/[-_ ](?:back|reverse)\\.[^.]+$/i.test(name);const rowValue=(row:CsvRow|undefined,...keys:string[])=>keys.map(key=>row?.[key]).find(Boolean)||'';const money=(value:string)=>{const parsed=Number((value||'').replace(/[$,]/g,''));return Number.isFinite(parsed)?parsed:null};\nconst normalizeHeader=(value:string)=>String(value||'').trim().toLowerCase().replace(/[^a-z0-9]+/g,'_').replace(/^_+|_+$/g,'');const normalizeToken=(value:string)=>normalizeHeader(value);const csvEscape=(value:unknown)=>{const text=String(value??'');return /[\",\\n\\r]/.test(text)?'\"'+text.replace(/\"/g,'\"\"')+'\"':text};const stableHash=(value:string)=>{let hash=2166136261;for(let index=0;index>>0).toString(36)};const slugLegacy=(value:string)=>normalizeHeader(value).replace(/_/g,'-').slice(0,64)||'record';\nfunction parseDelimited(text:string){const sample=String(text||'').split(/\\r?\\n/,1)[0]||'';const delimiter=(sample.match(/\\t/g)||[]).length>(sample.match(/,/g)||[]).length?'\\t':',';const matrix:string[][]=[];let row:string[]=[];let value='';let quoted=false;for(let index=0;indexcell.trim()))matrix.push(row);row=[];value='';continue}if(char!=='\\r')value+=char}row.push(value);if(row.some(cell=>cell.trim()))matrix.push(row);const headerRow=matrix.shift()||[];const seen=new Map();const headers=headerRow.map((cell,index)=>{const base=normalizeHeader(cell)||'column_'+(index+1);const count=(seen.get(base)||0)+1;seen.set(base,count);return count===1?base:base+'_'+count});const rows=matrix.map(cells=>Object.fromEntries(headers.map((header,index)=>[header,String(cells[index]??'').trim()]))) as CsvRow[];return{headers,rows,delimiter}}\nfunction parseCsv(text:string){return parseDelimited(text).rows}\nconst emptyLegacyMapping=()=>Object.fromEntries(LEGACY_FIELD_DEFS.map(def=>[def.key,''])) as LegacyMapping;\nfunction autoLegacyMapping(headers:string[]){const mapping=emptyLegacyMapping();for(const def of LEGACY_FIELD_DEFS){const match=def.aliases.map(normalizeHeader).find(alias=>headers.includes(alias));if(match)mapping[def.key]=match}return mapping}\nfunction mapped(row:CsvRow,mapping:LegacyMapping,key:LegacyFieldKey){const source=mapping[key];return source?String(row[source]||'').trim():''}\nfunction parsedNumber(value:string){if(!value.trim())return null;const parsed=Number(value.replace(/[$,%]/g,'').replace(/,/g,''));return Number.isFinite(parsed)?parsed:Number.NaN}\nfunction parsedDate(value:string){if(!value.trim())return null;const date=new Date(value);return Number.isNaN(date.getTime())?null:date.toISOString()}\nfunction downloadClientFile(name:string,content:string,type='text/csv;charset=utf-8'){const blob=new Blob([content],{type});const url=URL.createObjectURL(blob);const anchor=document.createElement('a');anchor.href=url;anchor.download=name;document.body.appendChild(anchor);anchor.click();anchor.remove();setTimeout(()=>URL.revokeObjectURL(url),0)}\nasync function fetchTenantRowsByValues(tenantId:string,table:string,column:string,values:string[],select:string){const clean=[...new Set(values.map(value=>String(value||'').trim()).filter(Boolean))];if(!clean.length)return[] as any[];const chunks:Array=[];for(let index=0;index(supabase as any).from(table).select(select).eq('tenant_id',tenantId).in(column,chunk)));const error=results.find(result=>result.error)?.error;if(error)throw error;return results.flatMap(result=>result.data||[])}\n\nfunction pairFiles(files:File[],rows:CsvRow[]){const map=new Map();for(const file of files.filter(item=>item.type.startsWith('image/'))){const key=fileStem(file.name);const item=map.get(key)||{key,status:'queued' as const};if(isBack(file.name))item.back=file;else if(!item.front)item.front=file;else map.set(`${key}-${map.size+1}`,{key:`${key}-${map.size+1}`,front:file,status:'queued'});map.set(key,item)}for(const item of map.values())item.row=rows.find(row=>fileStem(rowValue(row,'filename','file','front','image')).toLowerCase()===item.key.toLowerCase());return[...map.values()]}\nfunction ModeButton({active,children,onClick}:{active:boolean;children:React.ReactNode;onClick:()=>void}){return }\nfunction Stat({label,value,detail,icon:Icon}:{label:string;value:string;detail:string;icon:React.ComponentType<{className?:string}>}){return
{label}
{value}
{detail}
}\nfunction Field({label,value,onChange,placeholder}:{label:string;value:string;onChange:(value:string)=>void;placeholder?:string}){return }\nfunction ImageTile({label,file,onFile}:{label:string;file:File|null;onFile:(file:File|null)=>void}){return }\nfunction DemoCardFace({card}:{card:StoredCard}){const subject=String(card.player_character||card.brand_set||'Trading Card').replace(/^DEMO\\s*[—-]\\s*/i,'');const detail=[card.year,card.brand_set,card.card_number&&`#${card.card_number}`].filter(Boolean).join(' · ');return
PCG Demo
Trading card
{subject}
{detail||card.cert_number||'PCG sample record'}
}\n\nfunction LegacyMigrationStudio({tenantId,onImported}:{tenantId:string;onImported:()=>Promise}){const{toast}=useToast();const[fileName,setFileName]=useState('');const[headers,setHeaders]=useState([]);const[legacyRows,setLegacyRows]=useState([]);const[mapping,setMapping]=useState(emptyLegacyMapping());const[dryRun,setDryRun]=useState(null);const[working,setWorking]=useState(false);\nconst changeMapping=(key:LegacyFieldKey,value:string)=>{setMapping(current=>({...current,[key]:value}));setDryRun(null)};\nconst loadFile=async(file:File)=>{const text=await file.text();const parsed=parseDelimited(text);setFileName(file.name);setHeaders(parsed.headers);setLegacyRows(parsed.rows);setMapping(autoLegacyMapping(parsed.headers));setDryRun(null)};\nconst downloadTemplate=()=>downloadClientFile('pcg-legacy-migration-template.csv',LEGACY_FIELD_DEFS.map(def=>csvEscape(def.key)).join(',')+'\\n');\nconst exportIssues=()=>{if(!dryRun)return;const body=['row,severity,field,message,submission_number,cert_number,import_key',...dryRun.plans.flatMap(plan=>plan.issues.map(issue=>[issue.row,issue.severity,issue.field,issue.message,plan.submission.submission_number||'',plan.card.cert_number||'',plan.importKey].map(csvEscape).join(',')))].join('\\n');downloadClientFile('pcg-legacy-migration-report.csv',body)};\nasync function runDryRun(){if(!tenantId||!legacyRows.length)return;setWorking(true);try{const seenKeys=new Set();const seenCerts=new Set();const submissionFingerprints=new Map();const plans:LegacyPlan[]=legacyRows.map((row,index)=>{const rowNumber=index+2;const issues:LegacyIssue[]=[];const legacyId=mapped(row,mapping,'legacy_id');let submissionNumber=mapped(row,mapping,'submission_number');if(!submissionNumber&&legacyId)submissionNumber='LEGACY-'+slugLegacy(legacyId).toUpperCase();if(!submissionNumber){issues.push({row:rowNumber,severity:'error',field:'submission_number',message:'Map an order/submission number or a legacy record ID.'})}const rawSubmissionStatus=mapped(row,mapping,'submission_status');const submissionStatus=rawSubmissionStatus?(LEGACY_STATUS_MAP[normalizeToken(rawSubmissionStatus)]||''): 'received';if(rawSubmissionStatus&&!submissionStatus)issues.push({row:rowNumber,severity:'error',field:'submission_status',message:'Unknown legacy order status: '+rawSubmissionStatus});const rawCardStatus=mapped(row,mapping,'card_status');const cardStatus=rawCardStatus?(LEGACY_STATUS_MAP[normalizeToken(rawCardStatus)]||''):(submissionStatus||'received');if(rawCardStatus&&!cardStatus)issues.push({row:rowNumber,severity:'error',field:'card_status',message:'Unknown legacy card status: '+rawCardStatus});const rawTier=mapped(row,mapping,'service_tier');const serviceTier=rawTier?(LEGACY_TIER_MAP[normalizeToken(rawTier)]||'inventory'):'inventory';if(rawTier&&!LEGACY_TIER_MAP[normalizeToken(rawTier)])issues.push({row:rowNumber,severity:'warning',field:'service_tier',message:'Unrecognized service tier mapped to inventory: '+rawTier});const rawPayment=mapped(row,mapping,'payment_status');const paymentStatus=rawPayment?(LEGACY_PAYMENT_MAP[normalizeToken(rawPayment)]||'unverified'):'unverified';if(rawPayment&&!LEGACY_PAYMENT_MAP[normalizeToken(rawPayment)])issues.push({row:rowNumber,severity:'warning',field:'payment_status',message:'Unrecognized payment status mapped to unverified: '+rawPayment});const rawDelivery=mapped(row,mapping,'delivery_method');const deliveryMethod=rawDelivery?(LEGACY_DELIVERY_MAP[normalizeToken(rawDelivery)]||''):'';if(rawDelivery&&!deliveryMethod)issues.push({row:rowNumber,severity:'warning',field:'delivery_method',message:'Unrecognized delivery method omitted: '+rawDelivery});const servicePrice=parsedNumber(mapped(row,mapping,'service_price'));if(Number.isNaN(servicePrice))issues.push({row:rowNumber,severity:'error',field:'service_price',message:'Service price is not a valid number.'});const declaredValue=parsedNumber(mapped(row,mapping,'declared_value'));if(Number.isNaN(declaredValue))issues.push({row:rowNumber,severity:'error',field:'declared_value',message:'Declared value is not a valid number.'});const grade=parsedNumber(mapped(row,mapping,'grade'));if(Number.isNaN(grade))issues.push({row:rowNumber,severity:'error',field:'grade',message:'Grade is not a valid number.'});const rawSequence=mapped(row,mapping,'sequence_number');const sequenceValue=rawSequence?Number(rawSequence):null;if(rawSequence&&(!Number.isInteger(sequenceValue)||Number(sequenceValue)<=0))issues.push({row:rowNumber,severity:'error',field:'sequence_number',message:'Card sequence must be a positive whole number.'});const dateFields=(['received_at','due_at','completed_at'] as const).map(key=>{const raw=mapped(row,mapping,key);const value=parsedDate(raw);if(raw&&!value)issues.push({row:rowNumber,severity:'error',field:key,message:'Invalid date: '+raw});return[key,value] as const});const dates=Object.fromEntries(dateFields) as Record;const cert=mapped(row,mapping,'cert_number');const identity=[cert,mapped(row,mapping,'player_character'),mapped(row,mapping,'brand_set'),mapped(row,mapping,'year'),mapped(row,mapping,'card_number'),mapped(row,mapping,'card_description'),legacyId].filter(Boolean);if(!identity.length)issues.push({row:rowNumber,severity:'error',field:'card',message:'No usable card identity is mapped for this row.'});const importKey='legacy:'+slugLegacy(submissionNumber||legacyId||'unknown')+':'+(cert?'cert-'+slugLegacy(cert):stableHash(JSON.stringify(row)));let duplicate=false;if(seenKeys.has(importKey)){duplicate=true;issues.push({row:rowNumber,severity:'warning',field:'import_key',message:'Duplicate row inside this file; later copy will be skipped.'})}else seenKeys.add(importKey);if(cert){const certKey=cert.toLowerCase();if(seenCerts.has(certKey)){duplicate=true;issues.push({row:rowNumber,severity:'warning',field:'cert_number',message:'Duplicate certification number inside this file; later copy will be skipped.'})}else seenCerts.add(certKey)}const submission={submission_number:submissionNumber,customer_name:mapped(row,mapping,'customer_name')||null,customer_email:mapped(row,mapping,'customer_email')||null,customer_phone:mapped(row,mapping,'customer_phone')||null,service_tier:serviceTier,service_price:Number.isFinite(servicePrice as number)?servicePrice:0,status:submissionStatus||'received',payment_status:paymentStatus,delivery_method:deliveryMethod||null,tracking_in:mapped(row,mapping,'tracking_in')||null,tracking_out:mapped(row,mapping,'tracking_out')||null,notes:mapped(row,mapping,'submission_notes')||null,received_at:dates.received_at,due_at:dates.due_at,completed_at:dates.completed_at};const fingerprint=JSON.stringify([submission.customer_name,submission.customer_email,submission.customer_phone,submission.status]);if(submissionNumber){const prior=submissionFingerprints.get(submissionNumber);if(prior&&prior!==fingerprint)issues.push({row:rowNumber,severity:'error',field:'submission_number',message:'Rows for '+submissionNumber+' disagree on customer identity or order status.'});else submissionFingerprints.set(submissionNumber,fingerprint)}const card={sequence_number:sequenceValue&&Number.isInteger(sequenceValue)?sequenceValue:null,cert_number:cert||null,category:mapped(row,mapping,'category')||null,year:mapped(row,mapping,'year')||null,brand_set:mapped(row,mapping,'brand_set')||null,player_character:mapped(row,mapping,'player_character')||null,card_number:mapped(row,mapping,'card_number')||null,variation:mapped(row,mapping,'variation')||null,card_description:mapped(row,mapping,'card_description')||null,declared_value:Number.isFinite(declaredValue as number)?declaredValue:null,grade:Number.isFinite(grade as number)?grade:null,grade_label:mapped(row,mapping,'grade_label')||null,status:cardStatus||'received',grader_notes:mapped(row,mapping,'grader_notes')||null,front_source:mapped(row,mapping,'front_source')||null,back_source:mapped(row,mapping,'back_source')||null,legacy_id:legacyId||null};return{rowNumber,source:row,submission,card,importKey,issues,duplicate}});const submissionNumbers=[...new Set(plans.map(plan=>String(plan.submission.submission_number||'')).filter(Boolean))];const certs=[...new Set(plans.map(plan=>String(plan.card.cert_number||'')).filter(Boolean))];const importKeys=[...new Set(plans.map(plan=>plan.importKey).filter(Boolean))];const[existingSubmissions,existingCertCards,existingImportCards]=await Promise.all([fetchTenantRowsByValues(tenantId,'card_grading_submissions','submission_number',submissionNumbers,'id,submission_number,customer_name,customer_email,status'),fetchTenantRowsByValues(tenantId,'card_grading_cards','cert_number',certs,'id,submission_id,cert_number,import_key,player_character,brand_set,year,card_number,grade,status'),fetchTenantRowsByValues(tenantId,'card_grading_cards','import_key',importKeys,'id,submission_id,cert_number,import_key,player_character,brand_set,year,card_number,grade,status')]);const submissionMap=new Map(existingSubmissions.map((item:any)=>[String(item.submission_number),item]));const certMap=new Map(existingCertCards.filter((item:any)=>item.cert_number).map((item:any)=>[String(item.cert_number).toLowerCase(),item]));const importMap=new Map(existingImportCards.filter((item:any)=>item.import_key).map((item:any)=>[String(item.import_key),item]));for(const plan of plans){const existingSubmission=submissionMap.get(String(plan.submission.submission_number||''));plan.existingSubmissionId=existingSubmission?.id||null;if(existingSubmission){const sourceEmail=String(plan.submission.customer_email||'').toLowerCase();const existingEmail=String(existingSubmission.customer_email||'').toLowerCase();if(sourceEmail&&existingEmail&&sourceEmail!==existingEmail)plan.issues.push({row:plan.rowNumber,severity:'warning',field:'customer_email',message:'Existing order '+plan.submission.submission_number+' has a different customer email; existing order will be reused without overwrite.'})}const byCert=plan.card.cert_number?certMap.get(String(plan.card.cert_number).toLowerCase()):null;const byImport=importMap.get(plan.importKey);const existing=byCert||byImport;if(existing){const mismatches=[['player_character',plan.card.player_character],['brand_set',plan.card.brand_set],['year',plan.card.year],['card_number',plan.card.card_number]].filter(([key,value])=>value&&existing[key]&&String(value).trim().toLowerCase()!==String(existing[key]).trim().toLowerCase());if(mismatches.length){plan.issues.push({row:plan.rowNumber,severity:'error',field:byCert?'cert_number':'import_key',message:'Existing canonical card matches this identifier but has different card identity fields: '+mismatches.map(([key])=>key).join(', ')+'.'})}else{plan.duplicate=true;plan.issues.push({row:plan.rowNumber,severity:'warning',field:byCert?'cert_number':'import_key',message:'Canonical card already exists; this row will be skipped safely.'})}}}const issues=plans.flatMap(plan=>plan.issues);const safePlans=plans.filter(plan=>!plan.duplicate&&!plan.issues.some(issue=>issue.severity==='error'));const customerKeys=new Set(plans.map(plan=>String(plan.submission.customer_email||plan.submission.customer_phone||plan.submission.customer_name||'').trim().toLowerCase()).filter(Boolean));const uniqueSubmissionCount=new Set(plans.map(plan=>String(plan.submission.submission_number||'')).filter(Boolean)).size;const mediaRefs=plans.filter(plan=>plan.card.front_source||plan.card.back_source).length;setDryRun({plans,issues,summary:{rows:plans.length,customers:customerKeys.size,submissions:uniqueSubmissionCount,newSubmissions:submissionNumbers.filter(number=>!submissionMap.has(number)).length,existingSubmissions:submissionNumbers.filter(number=>submissionMap.has(number)).length,cards:plans.length,safeCards:safePlans.length,duplicates:plans.filter(plan=>plan.duplicate).length,conflicts:plans.filter(plan=>plan.issues.some(issue=>issue.severity==='error')).length,warnings:issues.filter(issue=>issue.severity==='warning').length,mediaRefs}})}catch(error){toast({title:'Migration dry run failed',description:error instanceof Error?error.message:String(error),variant:'destructive'})}finally{setWorking(false)}}\nasync function commitMigration(){if(!dryRun||dryRun.summary.conflicts>0||dryRun.summary.safeCards<1)return;setWorking(true);try{const safe=dryRun.plans.filter(plan=>!plan.duplicate&&!plan.issues.some(issue=>issue.severity==='error'));const groups=new Map();for(const plan of safe){const key=String(plan.submission.submission_number);if(!groups.has(key))groups.set(key,[]);groups.get(key)!.push(plan)}const newSubmissionPayloads=[...groups.entries()].filter(([,plans])=>!plans[0].existingSubmissionId).map(([submissionNumber,plans])=>{const first=plans[0].submission;return{tenant_id:tenantId,submission_number:submissionNumber,customer_name:first.customer_name,customer_email:first.customer_email,customer_phone:first.customer_phone,service_tier:first.service_tier||'inventory',service_price:first.service_price||0,status:first.status||'received',delivery_method:first.delivery_method,tracking_in:first.tracking_in,tracking_out:first.tracking_out,notes:first.notes,received_at:first.received_at,due_at:first.due_at,completed_at:first.completed_at,payment_status:first.payment_status||'unverified',expected_card_count:plans.length,is_demo:false}});for(let index=0;index[String(item.submission_number),String(item.id)]));const submissionIds=[...submissionIdMap.values()];const existingSequences=await fetchTenantRowsByValues(tenantId,'card_grading_cards','submission_id',submissionIds,'submission_id,sequence_number');const used=new Map>();for(const item of existingSequences){const key=String(item.submission_id);if(!used.has(key))used.set(key,new Set());used.get(key)!.add(Number(item.sequence_number)||0)}const nextSeq=new Map();for(const id of submissionIds){const values=[...(used.get(id)||new Set())];nextSeq.set(id,Math.max(0,...values)+1)}const importedAt=new Date().toISOString();const cards=safe.map(plan=>{const submissionId=submissionIdMap.get(String(plan.submission.submission_number));if(!submissionId)throw new Error('Submission resolution failed for '+plan.submission.submission_number);if(!used.has(submissionId))used.set(submissionId,new Set());const usedSet=used.get(submissionId)!;let sequence=Number(plan.card.sequence_number)||0;if(sequence<1||usedSet.has(sequence)){sequence=nextSeq.get(submissionId)||1;while(usedSet.has(sequence))sequence+=1;nextSeq.set(submissionId,sequence+1)}usedSet.add(sequence);const metadata={legacy_migration:{source:'owner_upload',source_file:fileName||'legacy-export',source_row:plan.rowNumber,legacy_id:plan.card.legacy_id||null,imported_at:importedAt,front_source:plan.card.front_source||null,back_source:plan.card.back_source||null,media_status:plan.card.front_source||plan.card.back_source?'pending_google_drive':'none'}};return{tenant_id:tenantId,submission_id:submissionId,sequence_number:sequence,cert_number:plan.card.cert_number,category:plan.card.category,year:plan.card.year,brand_set:plan.card.brand_set,player_character:plan.card.player_character,card_number:plan.card.card_number,variation:plan.card.variation,card_description:plan.card.card_description,declared_value:plan.card.declared_value,grade:plan.card.grade,grade_label:plan.card.grade_label,status:plan.card.status||'received',front_image_url:null,back_image_url:null,grader_notes:plan.card.grader_notes,import_key:plan.importKey,metadata,is_demo:false}});const withCert=cards.filter(card=>card.cert_number);const withoutCert=cards.filter(card=>!card.cert_number);for(let index=0;index
Legacy Migration Studio

Bring the old PCG history with you.

Stage a CSV or TSV export, map the columns, run a zero-write dry check, then commit only clean canonical records. Historical image references are recorded for later Google Drive migration; they are never copied into KNOCKLAUNCH storage here.

{dryRun?.issues.length?:null}
{headers.length?
Column mapping
Auto-mapped common names. Change anything that does not match Anthony’s export.
{LEGACY_FIELD_DEFS.map(def=>)}
:null}
Dry-run first. Always.
Nothing writes until a clean dry-run exists and you press Commit migration.
{dryRun?<>
{[['Rows',dryRun.summary.rows],['Customers',dryRun.summary.customers],['Orders',dryRun.summary.submissions],['Safe cards',dryRun.summary.safeCards],['Duplicates',dryRun.summary.duplicates],['Conflicts',dryRun.summary.conflicts]].map(([label,value])=>
{label}
{Number(value).toLocaleString()}
)}
{dryRun.summary.conflicts?dryRun.summary.conflicts+' row(s) must be fixed before commit':'Dry run is commit-safe'}
{dryRun.summary.newSubmissions} new order(s) · {dryRun.summary.existingSubmissions} existing order(s) reused · {dryRun.summary.warnings} warning(s) · {dryRun.summary.mediaRefs} row(s) reference legacy media that will remain pending for Google Drive migration.
Row-level preview
{dryRun.plans.slice(0,1000).map(plan=>{const hasError=plan.issues.some(issue=>issue.severity==='error');return
Row {plan.rowNumber}
{plan.submission.submission_number||'No order number'}
{plan.submission.customer_name||plan.submission.customer_email||'Customer not mapped'}
{plan.card.player_character||plan.card.card_description||plan.card.brand_set||plan.card.cert_number||'Card'}
{plan.card.cert_number?'Cert '+plan.card.cert_number:plan.importKey}
{hasError?'Conflict':plan.duplicate?'Duplicate':'Ready'}
{plan.issues.length?
{plan.issues.map((issue,index)=>
{issue.field}: {issue.message}
)}
:null}
})}
:null}}\n\nexport function PCGCardVaultContent({initialMode='overview'}:{initialMode?:VaultMode}={}){const{activeTenant}=useMultiTenant();const{toast}=useToast();const tenantId=activeTenant?.id||'';const[mode,setMode]=useState(initialMode);useEffect(()=>{setMode(initialMode)},[initialMode]);const[form,setForm]=useState(EMPTY_FORM);const[front,setFront]=useState(null);const[reverse,setReverse]=useState(null);const[saving,setSaving]=useState(false);const[rows,setRows]=useState([]);const[items,setItems]=useState([]);const[session,setSession]=useState('');const[running,setRunning]=useState(false);const[recent,setRecent]=useState([]);const[total,setTotal]=useState(0);const[submissionOptions,setSubmissionOptions]=useState([]);const[selectedSubmissionId,setSelectedSubmissionId]=useState('');const[driveState,setDriveState]=useState('checking');const stop=useRef(false);const done=items.filter(item=>item.status==='done').length;const failed=items.filter(item=>item.status==='failed').length;const remaining=items.filter(item=>item.status==='queued'||item.status==='failed');const progress=items.length?Math.round(((done+failed)/items.length)*100):0;const selectedSubmission=submissionOptions.find(item=>item.id===selectedSubmissionId)||null;const driveReady=driveState==='ready';\nasync function load(){if(!tenantId)return;setDriveState('checking');const[cardsResult,submissionResult,googleResult]=await Promise.all([(supabase as any).from('card_grading_cards').select('id,player_character,brand_set,year,card_number,front_image_url,grade,cert_number,metadata',{count:'exact'}).eq('tenant_id',tenantId).order('created_at',{ascending:false}).limit(12),(supabase as any).from('card_grading_submissions').select('id,submission_number,customer_name,status').eq('tenant_id',tenantId).order('created_at',{ascending:false}).limit(50),(supabase as any).from('tenant_provider_credentials').select('credential_status,metadata').eq('tenant_id',tenantId).eq('provider','google_workspace').maybeSingle()]);setRecent(cardsResult.data||[]);setTotal(Number(cardsResult.count||0));const eligible=((submissionResult.data||[]) as SubmissionOption[]).filter(item=>['received','intake_imaging','authentication','grading','encapsulation','qa'].includes(String(item.status||'')));setSubmissionOptions(eligible);setSelectedSubmissionId(current=>eligible.some(item=>item.id===current)?current:(eligible[0]?.id||''));const google=googleResult.data as any;const scopes=Array.isArray(google?.metadata?.granted_scopes)?google.metadata.granted_scopes.map((value:unknown)=>String(value)):[];setDriveState(google?.credential_status==='active'?(scopes.includes('https://www.googleapis.com/auth/drive.file')?'ready':'reconnect'):'missing')}useEffect(()=>{void load()},[tenantId]);\nasync function createSubmission(label:string){const{data,error}=await(supabase as any).from('card_grading_submissions').insert({tenant_id:tenantId,submission_number:`VAULT-${Date.now()}-${crypto.randomUUID().slice(0,6)}`,customer_name:'PCG Card Vault',service_tier:'inventory',service_price:0,status:'received',notes:label,payment_status:'unverified'}).select('id').single();if(error)throw error;return data.id}\nasync function upload(file:File,sessionKey:string,key:string,side:string,importKey:string):Promise{const{data}=await supabase.auth.getSession();if(!data.session?.access_token)throw new Error('Please sign in again.');const params=new URLSearchParams({tenant_id:tenantId,session_key:sessionKey,import_key:importKey,key,side,name:file.name,content_type:file.type||'application/octet-stream'});const response=await fetch(DRIVE_MEDIA_FN+'/upload?'+params.toString(),{method:'POST',headers:{Authorization:'Bearer '+data.session.access_token,'Content-Type':file.type||'application/octet-stream'},body:file});const payload=await response.json().catch(()=>null);if(!response.ok||!payload?.ok)throw new Error(payload?.error||'Google Drive upload failed');return{url:String(payload.url||''),fileId:String(payload.file_id||'')}}\nasync function storeCard(submissionId:string,importKey:string,frontMedia:DriveMedia|null,backMedia:DriveMedia|null,row?:CsvRow,values:Partial={},target?:{id?:string;sequenceNumber?:number}){const metadata={title:values.title||rowValue(row,'title','name'),grading_company:values.grader||rowValue(row,'grading_company','grader'),condition:values.condition||rowValue(row,'condition'),quantity:Number(values.qty||rowValue(row,'quantity')||1)||1,acquisition_cost:money(values.cost||rowValue(row,'acquisition_cost','cost')),estimated_value:money(values.value||rowValue(row,'estimated_value','value')),tags:String(values.tags||rowValue(row,'tags')).split(/[;,]/).map(item=>item.trim()).filter(Boolean),notes:values.notes||rowValue(row,'notes'),...(frontMedia?.fileId||backMedia?.fileId?{image_storage:'google_workspace_drive',drive_media:{provider:'google_workspace',front_file_id:frontMedia?.fileId||null,back_file_id:backMedia?.fileId||null}}:{})};const payload={tenant_id:tenantId,submission_id:submissionId,sequence_number:target?.sequenceNumber||1,category:values.category||rowValue(row,'category','sport'),year:values.year||rowValue(row,'year'),brand_set:values.set||rowValue(row,'brand_set','set','brand'),player_character:values.player||rowValue(row,'player','subject'),card_number:values.number||rowValue(row,'card_number','card_no'),declared_value:money(values.value||rowValue(row,'estimated_value','value')),grade:money(values.grade||rowValue(row,'grade')),grade_label:values.condition||rowValue(row,'condition'),cert_number:values.cert||rowValue(row,'cert_number','cert','serial'),front_image_url:frontMedia?.url||null,back_image_url:backMedia?.url||null,grader_notes:values.notes||rowValue(row,'notes')||null,status:'received',import_key:importKey,metadata};if(target?.id){const{error}=await(supabase as any).from('card_grading_cards').update(payload).eq('tenant_id',tenantId).eq('id',target.id);if(error)throw error;return}const{error}=await(supabase as any).from('card_grading_cards').upsert(payload,{onConflict:'tenant_id,import_key',ignoreDuplicates:true});if(error)throw error}\nasync function saveSingle(){if(!front&&!reverse)return toast({title:'Add at least one card image'});if(!driveReady)return toast({title:'Google Workspace Drive required',description:driveState==='reconnect'?'Reconnect Google Workspace so PCG has Drive file access.':'Connect Google Workspace before storing new PCG card images.',variant:'destructive'});setSaving(true);try{const sessionKey='single-'+crypto.randomUUID();const submissionId=await createSubmission('Single Card Vault upload');const frontMedia=front?await upload(front,sessionKey,'card','front',sessionKey):null;const backMedia=reverse?await upload(reverse,sessionKey,'card','back',sessionKey):null;await storeCard(submissionId,sessionKey,frontMedia,backMedia,undefined,form);setForm(EMPTY_FORM);setFront(null);setReverse(null);toast({title:'Card stored in PCG',description:'Master imagery is stored in the connected PCG Google Drive.'});await load()}catch(error){toast({title:'Could not save card',description:error instanceof Error?error.message:String(error),variant:'destructive'})}finally{setSaving(false)}}\nasync function runBatch(batch:BatchItem[]){if(!session||!batch.length)return;if(!selectedSubmissionId)return toast({title:'Select a grading order first',description:'Mass Intake attaches images to an existing collector order.',variant:'destructive'});if(!driveReady)return toast({title:'Google Workspace Drive required',description:driveState==='reconnect'?'Reconnect Google Workspace so PCG has Drive file access.':'Connect Google Workspace before starting image intake.',variant:'destructive'});const selected=submissionOptions.find(item=>item.id===selectedSubmissionId);if(!selected)return toast({title:'That grading order is no longer available',description:'Choose another open PCG order.',variant:'destructive'});setRunning(true);stop.current=false;let failedCount=0;try{const existingResult=await(supabase as any).from('card_grading_cards').select('id,sequence_number,import_key,front_image_url,back_image_url').eq('tenant_id',tenantId).eq('submission_id',selectedSubmissionId).order('sequence_number',{ascending:true});if(existingResult.error)throw existingResult.error;const existingCards=(existingResult.data||[]) as ExistingBatchCard[];const byImport=new Map(existingCards.filter(card=>card.import_key).map(card=>[String(card.import_key),card]));const blankSlots=existingCards.filter(card=>!card.import_key&&!card.front_image_url&&!card.back_image_url).sort((a,b)=>a.sequence_number-b.sequence_number);let nextSequence=Math.max(0,...existingCards.map(card=>Number(card.sequence_number)||0))+1;const plans=batch.map(item=>{const importKey=('pcg:'+selectedSubmissionId+':'+item.key).toLowerCase().replace(/[^a-z0-9:._-]+/g,'-');const existing=byImport.get(importKey);if(existing)return{item,importKey,existing:true,targetId:existing.id,sequenceNumber:existing.sequence_number};const slot=blankSlots.shift();return{item,importKey,existing:false,targetId:slot?.id,sequenceNumber:slot?.sequence_number||nextSequence++}});let cursor=0;const worker=async()=>{while(!stop.current){const index=cursor++;if(index>=plans.length)return;const plan=plans[index];const item=plan.item;try{setItems(current=>current.map(row=>row.key===item.key?{...row,status:'uploading',error:undefined}:row));if(!plan.existing){const frontMedia=item.front?await upload(item.front,session,item.key,'front',plan.importKey):null;const backMedia=item.back?await upload(item.back,session,item.key,'back',plan.importKey):null;await storeCard(selectedSubmissionId,plan.importKey,frontMedia,backMedia,item.row,undefined,{id:plan.targetId,sequenceNumber:plan.sequenceNumber})}setItems(current=>current.map(row=>row.key===item.key?{...row,status:'done'}:row))}catch(error){failedCount+=1;setItems(current=>current.map(row=>row.key===item.key?{...row,status:'failed',error:error instanceof Error?error.message:String(error)}:row))}}};await Promise.all(Array.from({length:Math.min(CONCURRENCY,plans.length)},worker));if(!stop.current&&failedCount===0&&selected.status==='received'){const advanced=await(supabase as any).rpc('advance_pcg_grading_submission',{p_tenant_id:tenantId,p_submission_id:selectedSubmissionId,p_status:'intake_imaging'});if(advanced.error)throw advanced.error}toast({title:stop.current?'Batch paused':failedCount?'Batch needs attention':'Order intake complete',description:failedCount?failedCount+' card'+(failedCount===1?'':'s')+' can be retried safely.':selected.submission_number+' now owns these canonical card records and Drive images.'});await load()}catch(error){toast({title:'Mass intake could not finish',description:error instanceof Error?error.message:String(error),variant:'destructive'})}finally{setRunning(false)}}const update=(key:keyof CardForm,value:string)=>setForm(current=>({...current,[key]:value}));\nreturn
PCG Card Vault

Card Vault

Capture one card or move an entire collection into PCG. Master imagery stays in the connected PCG Google Drive.

setMode('overview')}>OverviewsetMode('single')}>Single intakesetMode('batch')}>Mass intakesetMode('migration')}>Legacy migrationsetMode('growth')}>Growth Lab
{mode==='overview'?setMode('growth')}/>:null}\n{mode==='overview'?
Start an intake
Storage contract

Built for volume

{[['Google Drive masters','New originals live in the connected PCG Google Workspace, not KnockLaunch storage.'],['Safe retry','Completed imports keep a stable identity.'],['Canonical records','Single and batch intake write to the same card records.']].map(([title,copy])=>
{title}

{copy}

)}
:null}\n{mode==='growth'?
:null}\n{mode==='migration'?:null}\n{mode==='single'?
Card record

Identification & grading

update('title',value)}/>update('player',value)}/>update('year',value)}/>update('set',value)}/>update('number',value)}/>update('category',value)}/>update('grader',value)}/>update('grade',value)}/>update('cert',value)}/>update('condition',value)}/>update('qty',value)}/>update('cost',value)} placeholder=\"$0.00\"/>update('value',value)} placeholder=\"$0.00\"/>update('tags',value)} placeholder=\"rookie, refractor, auto\"/>